Re: How to change table owner?

Anders Bogdan  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