* pw <[EMAIL PROTECTED]> [2004-10-12 13:48:30 -0700]: > How can I cahnge the owner of the database to the proper user?
UPDATE pg_database SET datdba = (SELECT usesysid FROM pg_user WHERE usename = 'user_name') WHERE datname = 'database_name; There might be something you can do with 'alter database' as well. -- Steven Klassen - Lead Programmer Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Replication & Support Services, (503) 667-4564 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
