Re: search_path when restoring to new db - Mailing list pgsql-general

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