"SunWuKung" <Balazs.Klein@xxxxxxxxxxx> writes: > 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. ALTER DATABASE and ALTER USER commands are handled by pg_dumpall, not pg_dump. regards, tom lane
