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

SET command

From: "Roderick A(dot) Anderson" <raa(at)mailporter(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: SET command
Date: 2005-01-28 22:48:19
Message-ID: 41FAC133.40102@mailporter.net (view raw or flat)
Thread:
Lists: pgsql-admin
First off it has been a while since I needed to go to the 
www.postgresql.org documentation ( and site in general ) and the new 
layout/design is nice.

Now the question.

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.

A gentle whack with the clue-stick please.


TIA,
Rod
-- 
---
[This E-mail scanned for viruses by Declude Virus]


Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2005-01-28 22:53:10
Subject: Re: Help with access control settings in pg_hba.conf --
Previous:From: Victor DanilchenkoDate: 2005-01-28 20:38:38
Subject: Re: Help with access control settings in pg_hba.conf --

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