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