Re: Changing database owner (7.4) - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Changing database owner (7.4)
Date
Msg-id 4394CB05.1020709@commandprompt.com
Whole thread Raw
In response to Changing database owner (7.4)  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: Changing database owner (7.4)
List pgsql-general
Steve Crawford wrote:
> Changing the owner of a database is easy in 8.x (alter database...)
> but seems less so in 7.4.
>
> Is there a method of safely changing the owner of the database (via
> command or via updating pg* tables) in 7.4?
>
Use a transaction and use update to pg_database

Joshua D. Drake

> Cheers,
> Steve
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster


pgsql-general by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: Missing variable "role" in "pg_settings"?
Next
From: Steve Crawford
Date:
Subject: Re: Changing database owner (7.4)