Re: Set search_path - Mailing list pgsql-novice

From Jeffrey Melloy
Subject Re: Set search_path
Date
Msg-id 1BF6B9B4-AB9B-11D8-91AB-000393C78AC0@visualdistortion.org
Whole thread Raw
In response to Set search_path  ("Michael A Weber" <mweber@4wre.com>)
List pgsql-novice

On May 14, 2004, at 7:11 PM, Michael A Weber wrote:

<excerpt>

<fontfamily><param>Arial</param><x-tad-bigger>Is there a way to make
it ‘stick’ as it seems that it isn’t sticking?  Or, am I missing
something completely?  Please help!</x-tad-bigger></fontfamily>



</excerpt>set search_path simply sets it for your current session.


To set it permanently, do alter user <italic>username</italic> set
search_path = newpath;


Jeff


On May 14, 2004, at 7:11 PM, Michael A Weber wrote:
>
> Is there a way to make it ‘stick’ as it seems that it isn’t sticking? 
> Or, am I missing something completely?  Please help!
>
>
set search_path simply sets it for your current session.

To set it permanently, do alter user username set search_path = newpath;

Jeff

pgsql-novice by date:

Previous
From: Manuel Sugawara
Date:
Subject: Re: Problem with encode() function
Next
From: "hendro"
Date:
Subject: Re: New from mssql. Help please