[ADMIN] How to change table owner?

[Anders Bogdan]

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


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

http://archives.postgresql.org