How to change table owner?

From: Anders Bogdan <anders(at)theworks(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to change table owner?
Date: 2002-12-09 14:39:34
Message-ID: 08B936B4-0B84-11D7-BCC3-000393178BD6@theworks.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings!

Sort of a newbie-ish question, I haven't seen it in the archives so
thought I'd ask.
I've created and deployed a number of databases and am now getting
around to adding some table maintenance (a vacuum script). But, the
script can't run as the "postgres" user. It runs as a defined db user
"admin".. Unfortunately, in my db schema the tables are owned by
postgres and my script doesn't have permission to vacuum. ( I've since
changed the schema so this won't happen in the future)
I need to change owner of the tables from postgres to admin... Granting
all to admin apparently isn't enough. Is there are simple way to change
table owner short of dumping, editing the dump and restoring?
redhat7.2
postgresql7.1/7.2

Thanks
Anders

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-12-09 15:35:39 Re: How to change table owner?
Previous Message wishy wishy 2002-12-09 14:09:35 auto creation of database and schema