Thread: Change a database owner

Change a database owner

From
Cédric Mallet
Date:
I would like to know how to change the owner of a database ?
I have seen that I could do something like :

UPDATE pg_database SET datdba=99 WHERE datname=mydatabase;

but how do I know the right datdba ?

Thanx

Ced