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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general