Re: How to show the current schema or search path in the psql PROMP

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Schwaighofer Clemens <clemens(dot)schwaighofer(at)tequila(dot)jp>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to show the current schema or search path in the psql PROMP
Date: 2010-06-11 18:09:50
Message-ID: AANLkTinasGLjHCy4r2fUUPIrul_VDL4nA9QAc2RLMOoe@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 9, 2010 at 2:52 AM, Schwaighofer Clemens
<clemens(dot)schwaighofer(at)tequila(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-06-11 18:10:54 Re: How to show the current schema or search path in the psql PROMP
Previous Message DM 2010-06-11 17:40:29 Re: Enforcing password standards