Re: Allow COPY to use parameters

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: Allow COPY to use parameters
Дата
Msg-id 8737p7kt0g.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: Allow COPY to use parameters  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
>>>>> "Merlin" == Merlin Moncure <mmoncure@gmail.com> writes:
Merlin> Hm, what's the use case preparing COPY?

Preparing it isn't necessarily the point (and SQL-level PREPARE is not
addressed in that patch). The point is to allow parameters, so that a
client can do

COPY (select blah from whatever where thing = $1) TO ...

without having to mess around with interpolations.
Merlin> Note, the biggest pain point I have with COPY is not being ableMerlin> to parameterize the filename argument.

Certainly that can be handled too.

-- 
Andrew (irc:RhodiumToad)

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

Предыдущее
От: ilmari@ilmari.org (Dagfinn Ilmari Mannsåker)
Дата:
Сообщение: Re: To-Do item: skip table scan for adding column with provable check constraints
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: effective_io_concurrency in 9.6beta