Re: Parameter binding for COPY TO queries

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Parameter binding for COPY TO queries
Дата
Msg-id s45xxcatvkl3blte4jcaorrke6saddqamfuls4impcvhc3jnz7@kdewpeudwkik
обсуждение исходный текст
Ответ на Re: Parameter binding for COPY TO queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Parameter binding for COPY TO queries
Список pgsql-hackers
Hi,

On 2025-02-14 10:06:13 -0500, Tom Lane wrote:
> None of those arguments apply to the sub-SELECT of a "COPY (query) TO"
> command, but there's a practical matter of how to get the parameters
> passed through the COPY to the sub-SELECT without opening Pandora's
> box for every other kind of utility statement.

I think there's already precedent - CREATE TABLE AS does accept parameters
today, and it's a utility command too:

DROP TABLE IF EXISTS foo;
CREATE TABLE foo AS SELECT $1 as a, $2 as b \bind fooval, barval \g \d foo

Is there anything stopping us from implementing COPY along the same lines as
CTAS?  There's some special case code for it, but it seems within reason,
unless we want to make dozens of commands accepting parameters...

Greetings,

Andres Freund



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