Re: How to change database owner in 7.4

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: frank church <pgsql(at)adontendev(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to change database owner in 7.4
Date: 2005-11-30 20:19:36
Message-ID: 1133381975.16010.6.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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');

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-11-30 21:17:58 Re: Finding uniques across a big join
Previous Message Joshua D. Drake 2005-11-30 19:47:13 Re: [GENERAL] What is the deal with mailing lists?