On Wed, Jun 9, 2010 at 2:52 AM, Schwaighofer Clemens
<clemens.schwaighofer@tequila.jp> wrote:
> Hi,
>
> I am trying to figure out how I can show the current search_path, or
> better the first search_path entry (the active schema) in the PROMPT
> variable for psql.
>
> Is there any way to do that? I couldn't find anything useful ...
http://www.postgresql.org/docs/8.3/static/app-psql.html#APP-PSQL-PROMPTING
There are lots of things you can put into a prompt, but that doesn't
appear to be one of them. Seems like a reasonable feature request.