Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
Дата
Msg-id 28320.1479915854@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used  (Poul Kristensen <bcc5226@gmail.com>)
Список pgsql-general
Дерево обсуждения 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Wed, Nov 23, 2016 at 3:46 AM, Poul Kristensen <bcc5226@gmail.com> wrote:
>> In the postgresql.log I get "select datname from $1".

> ​That is expected when you parameterize a query - the query string includes
> parameter​s instead of values.

It looks like Poul is hoping to use a parameter as a table name,
which doesn't work.  Parameters can only represent values (constants).

            regards, tom lane

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Postgresql 9.5 and Shell scripts/variables vs. C programming/defining a value to be used
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [SPAM] Re: Best practices to manage custom statistics