On 20/2/06 1:26 pm, "Peter Eisentraut" <[EMAIL PROTECTED]> 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? http://www.postgresql.org/docs/faq