Re: Doing a \set through perl DBI ?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Doing a \set through perl DBI ?
Дата
Msg-id CAKFQuwYsDgQd+x598aWWf05FzfTEXxnSJXQCZQ=SSZ8RyaiM5w@mail.gmail.com
обсуждение исходный текст
Ответ на Doing a \set through perl DBI ?  (David Gauthier <davegauthierpg@gmail.com>)
Ответы Re: Doing a \set through perl DBI ?
Список pgsql-general
On Wednesday, June 6, 2018, David Gauthier <davegauthierpg@gmail.com> wrote:
Hi:

Is there a way to do the equivalent of a "\set foo 1" through perl dbi ?
I tried... 
    $dbh->do("\\set foo 1");
and got a syntax error

Of course, I'd also have to be able to access the value of foo once its set.   I'm guessing the usual way ??? (select :foo)


No.  Meta commands are psql client program only.  You'd need to explain why you want this to get reasonable server-side suggestions.

David J.
 

В списке pgsql-general по дате отправления:

Предыдущее
От: David Gauthier
Дата:
Сообщение: Doing a \set through perl DBI ?
Следующее
От: Jerry Sievers
Дата:
Сообщение: Re: Which backend using which pg_temp_N schema?