Postgres Pro
Downloads
Home   >   mailing lists

Re: Moving several databases into one database with several schemas - Mailing list pgsql-general

From John R Pierce
Subject Re: Moving several databases into one database with several schemas
Date
Msg-id 5048EE1C.2040907@hogranch.com
Whole thread Raw
In response to Re: Moving several databases into one database with several schemas  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: Moving several databases into one database with several schemas
List pgsql-general
Tree view 
On 09/06/12 5:30 AM, Edson Richter wrote:
>> You could change the default setting for the user with
>>
>> ALTER ROLE someuser SET search_path=...
> That is perfect! I can have separate users for each application, and
> then they will have the correct search path.
> You saved my day,

the default search_path is $USER,public, so by naming your schema's to
the usernames, you don't even need to alter role...



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

pgsql-general by date:

Previous
From: Misa Simic
Date:
Subject: Re: pivot functions with variable number of columns
Next
From: Willy-Bas Loos
Date:
Subject: Re: return text from explain