Re: PSQLRC environment variable. - Mailing list pgsql-patches

From Tom Lane
Subject Re: PSQLRC environment variable.
Date
Msg-id 2365.1078893478@sss.pgh.pa.us
Whole thread Raw
In response to Re: PSQLRC environment variable.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: PSQLRC environment variable.  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-patches
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> Uh, why is that a good idea?

> Well, suppose you want all your users to use the same psqlrc file.
> Instead of creating symlinks for every user, you can just set PSQLRC in
> /etc/profile and everyone gets it.

... but people who want to make their own .psqlrc can't?  At least not
till it occurs to them to unset PSQLRC?  I don't really see the use-case
here.  James' stated problem of setting a default search_path could be
handled at least as effectively through either PGOPTIONS or server-side
GUC settings (postgresql.conf, or per-user or per-database variable
settings).

I'm not averse to inventing PSQLRC if there's actually some case it
solves better than any of our existing mechanisms.  But so far it seems
like a solution desperately in search of a problem.

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: PSQLRC environment variable.
Next
From: mike g
Date:
Subject: Initial Review of Copy Command Patch