Re: COPY support for parameters - Mailing list pgsql-hackers

From Tom Lane
Subject Re: COPY support for parameters
Date
Msg-id 12415.1550157763@sss.pgh.pa.us
Whole thread Raw
In response to COPY support for parameters  (Adrian Phinney <adrian.phinney+postgres@gmail.com>)
List 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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Early WIP/PoC for inlining CTEs
Next
From: Peter Eisentraut
Date:
Subject: Re: Early WIP/PoC for inlining CTEs