Re: [GENERAL] search_path when restoring to new db

[Tom Lane]

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

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq