Re: search_path when restoring to new db

"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.

            regards, tom lane