Postgres Pro
Downloads
Home   >   mailing lists

Changing database ownership - Mailing list pgsql-general

From Mitch
Subject Changing database ownership
Date
Msg-id D1E1B75E-E15C-11D6-B3A7-0003938024CA@doot.org
Whole thread Raw
List pgsql-general
Tree view 
Is there any more graceful way of changing a databases owner than :

update pg_database SET datdba = <id of user I want to own the db> where
datname='database_name'; ?

Thanks!!!

-Mitch

Without order nothing can exist - without chaos nothing can evolve.

pgsql-general by date:

Previous
From: Jorge Rojas
Date:
Subject: Inquiry From Form [pgsql]
Next
From: Steve Lane
Date:
Subject: Working with foreign key constraints