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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
