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. Regards, Moiz Kothari On 10/30/07, Vishesh Jain <[EMAIL PROTECTED]> wrote: > > > The following bug has been logged online: > > Bug reference: 3709 > Logged by: Vishesh Jain > Email address: [EMAIL PROTECTED] > 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 : http://dailyhealthtips.blogspot.com
