Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: search_path when restoring to new db
Date
Msg-id 12773.1165853207@sss.pgh.pa.us
Whole thread Raw
In response to search_path when restoring to new db  ("SunWuKung" <Balazs.Klein@t-online.hu>)
Responses Re: search_path when restoring to new db  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: "Yonatan Ben-Nes"
Date:
Subject: Numeric or Integer for monetary values?
Next
From: Richard Broersma Jr
Date:
Subject: Creating multiple Rules for on update