pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSET command
2+ messages / 2 participants
[nested] [flat]
* SET command
@ 2005-01-28 22:48 Roderick A. Anderson <raa@mailporter.net>
2005-01-28 23:45 ` Re: SET command Michael Fuhr <mike@fuhr.org>
0 siblings, 1 reply; 2+ messages in thread
From: Roderick A. Anderson @ 2005-01-28 22:48 UTC (permalink / raw)
To: 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]
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: SET command
2005-01-28 22:48 SET command Roderick A. Anderson <raa@mailporter.net>
@ 2005-01-28 23:45 ` Michael Fuhr <mike@fuhr.org>
0 siblings, 0 replies; 2+ messages in thread
From: Michael Fuhr @ 2005-01-28 23:45 UTC (permalink / raw)
To: Roderick A. Anderson <raa@mailporter.net>; +Cc: 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/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-01-28 23:45 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-28 22:48 SET command Roderick A. Anderson <raa@mailporter.net>
2005-01-28 23:45 ` Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox