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

Re: SET command

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Roderick A(dot) Anderson" <raa(at)mailporter(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: SET command
Date: 2005-01-28 23:45:07
Message-ID: 20050128234507.GA66863@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Fri, Jan 28, 2005 at 02:48:19PM -0800, Roderick A. Anderson wrote:

> I'm reading up on schema and trying to remember from when I last 
> researched them what the process is to make the
> 
> 	SET search_path TO myschema,public;
> 
> permanent for users when they sign on.  The documentation implies that 
> it is only per SESSION or transaction (LOCAL).  I seem to remember some 
> setting that cause these to be stored and then executed each time a user 
> connected.

You can set variables globally in postgresql.conf, per database with
ALTER DATABASE, or per user with ALTER USER.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

  • SET command at 2005-01-28 22:48:19 from Roderick A. Anderson

pgsql-admin by date

Next:From: "Miquel van Smoorenburg" Date: 2005-01-29 17:16:38
Subject: Re: Installing PostgreSQL as "postgress" versus "root" Debate!
Previous:From: Tom LaneDate: 2005-01-28 22:53:10
Subject: Re: Help with access control settings in pg_hba.conf --

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