Re: search_path when restoring to new db

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "SunWuKung" <Balazs(dot)Klein(at)t-online(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: search_path when restoring to new db
Date: 2006-12-11 16:06:47
Message-ID: 12773.1165853207@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"SunWuKung" <Balazs(dot)Klein(at)t-online(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Broersma Jr 2006-12-11 16:08:29 Creating multiple Rules for on update
Previous Message Yonatan Ben-Nes 2006-12-11 15:50:44 Numeric or Integer for monetary values?