[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] change ownership on all tables
From:       John R Pierce <pierce () hogranch ! com>
Date:       2009-07-31 18:57:12
Message-ID: 4A733E88.2010905 () hogranch ! com
[Download RAW message or body]

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
[prev in list] [next in list] [prev in thread] [next in thread]