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"
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
