Regards
On Thu, Oct 28, 2010 at 12:23 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:
2010/10/28 akp geek <akpgeek@xxxxxxxxx>:
hello> 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 difficult for
> functions, sequences
> Thanks for your help
> Regards
use a statement: ALTER TABLE tablename SET SCHEMA new_schema
Regards
Pavel Stehule
