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

From SunWuKung
Subject search_path when restoring to new db
Date
Msg-id 1165851313.808539.51500@79g2000cws.googlegroups.com
Whole thread Raw
Responses Re: search_path when restoring to new db  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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. I

s this realy the case or I am doing something wrong and there is a way
to have the backup-restore do this automatically?

Thanks.
Balázs


pgsql-general by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: TOAD-like query builder for PostgreSQL?
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Re: Hi