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 AANLkTikMewzDXBlcOpnAiyJAyy-tYCfa1_jc4ev-74-U@mail.gmail.com
Whole thread Raw
In response to Re: How to show the current schema or search path in the psql PROMP  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How to show the current schema or search path in the psql PROMP  (Clemens Schwaighofer <clemens_schwaighofer@e-gra.co.jp>)
List pgsql-general
Tree view 
On Fri, Jun 11, 2010 at 2:18 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Scott Marlowe <scott.marlowe@gmail.com> writes:
>> But that runs a shell command, how's that supposed to get the
>> search_path?  I've been trying to think up a solution to that and
>> can't come up with one.
>
> Yeah, and you do *not* want the prompt mechanism trying to send SQL
> commands...

Would a more generic way to access pgsql settings in a \set prompt be useful?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to show the current schema or search path in the psql PROMP
Next
From: Sergey Konoplev
Date:
Subject: Re: Moving a live production database to different server and postgres release