> 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