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

Reply via email to