Re: search_path when restoring to new db

[Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx>]

On Mon, 2006-12-11 at 10:06, Tom Lane wrote:
> "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.

And you can use pg_dumpall -s to get those:

pg_dumpall -s|grep -i "alter database"|grep -i search_path