Thanks a lot. Regards
On Thu, Oct 28, 2010 at 12:23 PM, Pavel Stehule <pavel.steh...@gmail.com>wrote: > 2010/10/28 akp geek <akpg...@gmail.com>: > > 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 > > hello > > use a statement: ALTER TABLE tablename SET SCHEMA new_schema > > Regards > > Pavel Stehule >
