SEO

#1 (**permalink**) 04-09-2008, 07:13 AM

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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

#2 (**permalink**) 04-09-2008, 07:13 AM

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

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

How to change database owner in 7.4