On Wed, Jun 9, 2010 at 2:52 AM, Schwaighofer Clemens <clemens.schwaighofer@xxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general