30. PostgreSQL DBA: How to Drop a user without dropping their data in PostgreSQL

In this video,we will see how to Drop a user without dropping their data in PostgreSQL.

Commands used.

1) drop user george;
2) alter user george nologin;
3) REASSIGN OWNED BY george to james;
4) drop user george;

How to Drop a user without dropping their data in PostgreSQL
Drop a user without dropping their data in PostgreSQL
How to drop user without dropping data postgresql
PostgreSQL drop user without data.
ERROR: role "" cannot be dropped because some objects depend on it