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