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])