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