Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group