Re: Parameter binding for COPY TO queries - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Parameter binding for COPY TO queries
Date
Msg-id 3901594.1739566311@sss.pgh.pa.us
Whole thread Raw
In response to Re: Parameter binding for COPY TO queries  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Andres Freund <andres@anarazel.de> 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 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:

Hmm ... yeah, now that I look, there's more pre-existing plumbing
in ProcessUtility than I remembered.  So maybe this wouldn't be too
hard after all.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: New buildfarm animals with FIPS mode enabled
Next
From: Daniel Gustafsson
Date:
Subject: Re: Feature Request: Add AES-128-CFB Mode Support to pgcrypto