change ownership on all tables

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
Thread:
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"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2009-07-31 18:43:10 Re: Can I have a look at your TuningWizard generated config file?
Previous Message Arnold, Sandra 2009-07-31 18:31:46 Re: Limiting records in pg_dump