Change a database owner - Mailing list pgsql-novice

From Cédric Mallet
Subject Change a database owner
Date
Msg-id 39145428965.20020529183259@cti.ecp.fr
Whole thread Raw
List pgsql-novice
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



pgsql-novice by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Fantasy Football complex select
Next
From: Wei Weng
Date:
Subject: psql without password prompt