Re: How to change table owner?

Anders Bogdan <anders@theworks.org> writes:
> 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.

Make "admin" a postgres superuser.  (I think "ALTER USER admin CREATEUSER"
is the approved way to do this.)

            regards, tom lane