[GENERAL] search_path when restoring to new db

[SunWuKung]

It seems to me that if I dump and restore a database as a new db I need
to manually issue
ALTER DATABASE dbname SET search_path=schema1, schema2;
to get back the search_path of the original db. I

s this realy the case or I am doing something wrong and there is a way
to have the backup-restore do this automatically?

Thanks.
Balázs


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq