Re: [GENERAL] moving database objects from one schema to other

2010-10-28 Thread akp geek
Thanks a lot. Regards On Thu, Oct 28, 2010 at 12:23 PM, Pavel Stehule wrote: > 2010/10/28 akp geek : > > Hi all - > > I would like to know if there is any other way of moving > > objects from one schema to other schema? right now the way I am doing it > is > > , take the backup and

Re: [GENERAL] moving database objects from one schema to other

2010-10-28 Thread Pavel Stehule
2010/10/28 akp geek : > Hi all - >               I would like to know if there is any other way of moving > objects from one schema to other schema? right now the way I am doing it is > , take the backup and importing whatever the database objects I wanted to > move, I am doing that using pg_restor

Re: [GENERAL] moving database objects from one schema to other

2010-10-28 Thread Thom Brown
On 28 October 2010 17:11, akp geek wrote: > Hi all - >               I would like to know if there is any other way of moving > objects from one schema to other schema? right now the way I am doing it is > , take the backup and importing whatever the database objects I wanted to > move, I am doing

[GENERAL] moving database objects from one schema to other

2010-10-28 Thread akp geek
Hi all - I would like to know if there is any other way of moving objects from one schema to other schema? right now the way I am doing it is , take the backup and importing whatever the database objects I wanted to move, I am doing that using pg_restore. But I am finding it difficul