Tag: owner

PostgreSQL ERROR: role cannot be dropped because some objects depend on it

We are going to see the solution for “PostgreSQL ERROR: role cannot be dropped because some objects depend on it”

ERROR:  role "james" cannot be dropped because some objects depend on it
DETAIL:  owner of database emp
6 objects in database r2schools
1 object in database postgres
3 objects in database newdb
3 objects in database emp

PostgreSQL ERROR: role cannot be dropped because some objects depend on it

Solution:
Continue reading PostgreSQL ERROR: role cannot be dropped because some objects depend on it

Related Posts:

  1. How to find currently logged in users in PostgreSQL
  2. How to rename PostgreSQL User
  3. How to switch role after connecting to database in PostgreSQL
  4. PostgreSQL Create User

How to change owner of database in PostgreSQL

In this tutorial, we will see How to change owner of database in PostgreSQL. We can change the database owner by using ALTER DATABASE command. If we change the owner name, only database owner name will cnage. But not objects(tables, views,…) owners.

Syntax to change the owner of the database in PostgreSQL: Continue reading How to change owner of database in PostgreSQL

Related Posts:

  1. Check the database size in PostgreSQL
  2. How to Copy table from one database to another in PostgreSQL
  3. How to rename PostgreSQL User
  4. How to take backup and restore a PostgreSQL Database