2010/10/28 akp geek <akpgeek@xxxxxxxxx>: > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
