Re: Set search_path

From: Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org>
To: "Michael A Weber" <mweber(at)4wre(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Set search_path
Date: 2004-05-22 02:52:48
Message-ID: 1BF6B9B4-AB9B-11D8-91AB-000393C78AC0@visualdistortion.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message hendro 2004-05-22 10:29:10 Re: New from mssql. Help please
Previous Message Manuel Sugawara 2004-05-21 22:21:32 Re: Problem with encode() function