Re: Parameter binding for COPY TO queries

2025-02-14 Thread Tom Lane
Andres Freund writes: > 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

Re: Parameter binding for COPY TO queries

2025-02-14 Thread Andres Freund
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 util

Re: Parameter binding for COPY TO queries

2025-02-14 Thread Tom Lane
Jens-Wolfhard Schicke-Uffmann writes: > I'd like some input on the idea of adding parameter binding support to > queries executed as part of a COPY TO command. Is there a technical > or philosophical reason why these queries should not contain bindable > parameters? It would require some rethinki

Parameter binding for COPY TO queries

2025-02-14 Thread Jens-Wolfhard Schicke-Uffmann
Hi, I'd like some input on the idea of adding parameter binding support to queries executed as part of a COPY TO command. Is there a technical or philosophical reason why these queries should not contain bindable parameters? As far as I could ascertain, the feature has been desired for a long tim