search_path when restoring to new db

From: "SunWuKung" <Balazs(dot)Klein(at)t-online(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: search_path when restoring to new db
Date: 2006-12-11 15:35:13
Message-ID: 1165851313.808539.51500@79g2000cws.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yonatan Ben-Nes 2006-12-11 15:50:44 Numeric or Integer for monetary values?
Previous Message Shoaib Mir 2006-12-11 15:33:17 Re: TOAD-like query builder for PostgreSQL?