On Mon, 2006-12-11 at 10:06, Tom Lane wrote:
> "SunWuKung" <Balazs(dot)Klein(at)t-online(dot)hu> 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