Re: DBs and Schemas

On Jan 6, 2004, at 3:27 PM, Oliver Elphick wrote:

> On Tue, 2004-01-06 at 22:06, Adam Ruth wrote:
>>> 1. Modifying the applications to use schemas instead of connecting to
>>>    specific databases.  Getting the authors to use schemas so I do it
>>>    once.
>>
>> 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.
>
> You can use ALTER DATABASE to set that up permanently, without touching
> the application.

If you were combining several databases into one database with several
schemas, each application will use a different schema.  Thus each
application would need to specify which schema it's using when starting
up.