Thread: How to change database owner in 7.4

Hi guys,

What is the command change database owner in PostgreSQL 7.4?

I think the 'ALTER DATABASE foo OWNER TO blob;' is not implemented in 7.4

R Church

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.

On Wed, 2005-11-30 at 12:08, frank church wrote:
> Hi guys,
>
> What is the command change database owner in PostgreSQL 7.4?
>
> I think the 'ALTER DATABASE foo OWNER TO blob;' is not implemented in 7.4
>


update pg_database set datdba=(select usesysid from pg_user where
usename='newowner');