Tom Lane <[EMAIL PROTECTED]> 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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to