On Mon, 2006-12-11 at 10:06, Tom Lane wrote: > "SunWuKung" <[EMAIL PROTECTED]> 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.
And you can use pg_dumpall -s to get those: pg_dumpall -s|grep -i "alter database"|grep -i search_path ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
