| From: | "Roderick A(dot) Anderson" <raanders(at)acm(dot)org> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: DBs and Schemas |
| Date: | 2004-01-06 23:19:25 |
| Message-ID: | Pine.LNX.4.33.0401061516001.7816-100000@main.cyber-office.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 6 Jan 2004, Adam Ruth wrote:
> One thing I'd suggest would be to modify the application to issue a
> "set search_path = yourschema;" at the beginning, then the rest of the
> application wouldn't need to change. That's what I did when I did
> something similar.
Neat idea. I was thinking that most of the applications use a specific id
to access their database so I was going to do this at the user level
(alter user). I think it will depend on the specific application as to
how I'd do this.
Rod
--
"Open Source Software - You usually get more than you pay for..."
"Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roderick A. Anderson | 2004-01-06 23:34:21 | Re: DBs and Schemas |
| Previous Message | Oliver Elphick | 2004-01-06 22:27:41 | Re: DBs and Schemas |