Thread: change ownership on all tables

OK, my DB Admin is on vacation, and 15 minutes of googling didn't get
me the answer :-)

Although in that 15 minutes I could have done all 109 tables manually :-)

I know this command for a single table, and checked the manual but
don't see anything about wildcards

ALTER TABLE tablename OWNER to user;

PG 8.4

--
“Don't eat anything you've ever seen advertised on TV”
         - Michael Pollan, author of "In Defense of Food"

Alan McKay wrote:
> OK, my DB Admin is on vacation, and 15 minutes of googling didn't get
> me the answer :-)
>
> Although in that 15 minutes I could have done all 109 tables manually :-)
>
> I know this command for a single table, and checked the manual but
> don't see anything about wildcards
>
> ALTER TABLE tablename OWNER to user;
>

see http://pgedit.com/public/sql/acl_admin/index.html
or http://www.archonet.com/pgdocs/grant-all.html

these are scripts for doing a GRANT to all objects, but they should
easily be modifiable to do a ALTER TABLE... OWNER