Обсуждение: Change a database owner

Поиск
Список
Период
Сортировка

Change a database owner

От
Cédric Mallet
Дата:
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