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

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: How to show the current schema or search path in the psql PROMP
Дата
Msg-id AANLkTikMewzDXBlcOpnAiyJAyy-tYCfa1_jc4ev-74-U@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to show the current schema or search path in the psql PROMP  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: How to show the current schema or search path in the psql PROMP  (Clemens Schwaighofer <clemens_schwaighofer@e-gra.co.jp>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to show the current schema or search path in the psql PROMP
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: Moving a live production database to different server and postgres release