Skip site navigation (1) Skip section navigation (2)

Re: BUG #3709: Changing Table Owner

From: "Moiz Kothari" <moizpostgres(at)gmail(dot)com>
To: "Vishesh Jain" <vishesh(dot)jain(at)tcs(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3709: Changing Table Owner
Date: 2007-10-30 11:26:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
Hi Vishesh,

You can run a dynamic SQL to get all your table owner changed. Try doing
this :

login to your database with postgresql user and then

select 'alter table '|| tablename ||' owner to <self defined owner>;' from
pg_tables where schemaname = 'public';

copy the alter table statements and run it.

Moiz Kothari

On 10/30/07, Vishesh Jain <vishesh(dot)jain(at)tcs(dot)com> wrote:
> The following bug has been logged online:
> Bug reference:      3709
> Logged by:          Vishesh Jain
> Email address:      vishesh(dot)jain(at)tcs(dot)com
> PostgreSQL version: 8
> Operating system:   Linux
> Description:        Changing Table Owner
> Details:
> I need to change the owner of some tables from postgres to 'self defined
> owner'. Is there any such table where the change in the owner will be
> reflected in all the tables? Or any such configuration file to do the
> same?
> Or any ALTER statement?
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

Hobby Site :

In response to

pgsql-bugs by date

Next:From: Roger MoloneyDate: 2007-10-30 17:55:53
Subject: Fw: BUG #3695: Pgsql does not report non existing function
Previous:From: Vishesh JainDate: 2007-10-30 07:35:42
Subject: BUG #3709: Changing Table Owner

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group