Re: COPY support for parameters

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: COPY support for parameters
Дата
Msg-id 12415.1550157763@sss.pgh.pa.us
обсуждение исходный текст
Ответ на COPY support for parameters  (Adrian Phinney <adrian.phinney+postgres@gmail.com>)
Список pgsql-hackers
Adrian Phinney <adrian.phinney+postgres@gmail.com> writes:
> Does Postgres support COPY with parameters?

No.  In general you can only use parameters in DML statements
(SELECT/INSERT/UPDATE/DELETE); utility statements don't cope,
mainly because most of them lack expression eval capability
altogether.

Perhaps the special case of COPY from a SELECT could be made
to allow parameters inside the SELECT, but I don't think
anyone has tried.

            regards, tom lane


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Early WIP/PoC for inlining CTEs
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Early WIP/PoC for inlining CTEs