| Lists: | pgsql-general |
|---|
| From: | Alan McKay <alan(dot)mckay(at)gmail(dot)com> |
|---|---|
| To: | Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | change ownership on all tables |
| Date: | 2009-07-31 18:32:21 |
| Message-ID: | 844129e80907311132x4ba23ef0n128b0d873058c1fe@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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"
| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | Alan McKay <alan(dot)mckay(at)gmail(dot)com> |
| Cc: | Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: change ownership on all tables |
| Date: | 2009-07-31 18:57:12 |
| Message-ID: | 4A733E88.2010905@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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