Postgres Pro
Downloads
Home   >   mailing lists

Re: How to show the current schema or search path in the psql PROMP - Mailing list pgsql-general

From Scott Marlowe
Subject Re: How to show the current schema or search path in the psql PROMP
Date
Msg-id AANLkTinasGLjHCy4r2fUUPIrul_VDL4nA9QAc2RLMOoe@mail.gmail.com
Whole thread Raw
In response to How to show the current schema or search path in the psql PROMP  (Schwaighofer Clemens <clemens.schwaighofer@tequila.jp>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: DM
Date:
Subject: Re: Enforcing password standards
Next
From: Scott Marlowe
Date:
Subject: Re: How to show the current schema or search path in the psql PROMP