Tom Lane <tgl@sss.pgh.pa.us> writes:
> Another possibility is to issue the SET from a ~/.psqlrc file (I think
> that's what it's called, check the man page).
Yet another possibility is to use the existing PGOPTIONS env var:
%PGOPTIONS='-c search_path=foo,public' psql template1
[ ... ]
template1=# show search_path;
search_path
-------------
foo,public
(1 row)
> (Seen in this light, PGCLIENTENCODING is a wart, but I suppose we
> have to keep it for backwards compatibility.)
I seems to me that PGGEQO, PGTZ, and PGDATESTYLE fall into the same
category.
-Neil
