On 28 October 2010 17:11, akp geek <akpgeek@xxxxxxxxx> 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 that using pg_restore. But I am finding it difficult for > functions, sequences > Thanks for your help > Regards Yes, you just need to assign a new schema: ALTER TABLE table_name SET SCHEMA new_schema; ALTER FUCNTION function_name SET SCHEMA new_schema; etc... -- Thom Brown Twitter: @darkixion IRC (freenode): dark_ixion Registered Linux user: #516935 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
