append to the current search_path - Mailing list pgsql-general

From TJ O'Donnell
Subject append to the current search_path
Date
Msg-id 42FD4D53.3090008@acm.org
Whole thread Raw
Responses Re: append to the current search_path  (Michael Fuhr <mike@fuhr.org>)
List 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

pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: insert performance riddle
Next
From: Michael Fuhr
Date:
Subject: Re: append to the current search_path