append to the current search_path

From: TJ O'Donnell <tjo(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: append to the current search_path
Date: 2005-08-13 01:30:59
Message-ID: 42FD4D53.3090008@acm.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How can I append to the current search_path?
How can I put $user (back) into the search path?
These commands all fail:
set search_path $user,public,gnova;
set search_path \$user,public,gnova;
set search_path '$user',public,gnova;

Ideally, I would like something like PATH=${PATH}:/usr/local/bin
where I can get the current value and just append to it.

TJ

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-08-13 02:36:52 Re: append to the current search_path
Previous Message Ed L. 2005-08-13 00:45:44 Re: insert performance riddle