On 20/2/06 1:26 pm, "Peter Eisentraut" <peter_e@gmx.net> wrote:
> Am Montag, 20. Februar 2006 14:15 schrieb Q Beukes: >> Hey, >> >> This might not be much, but can there maybe be a future feature for >> having a shortcut to "set search_path='schema-name';" >> similiar to \c dbname ?? > > pei=# \set X 'set search_path = ' > pei=# :X public; > SET > pei=# show search_path; > search_path > ------------- > public
That seems quite handy to know! can these be saved anywhere such that I don't have to run the \set <...> command every session?
Thanks
Adam
-- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ?