Re: COPY support for parameters

2019-02-14 Thread Tom Lane
Adrian Phinney 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 COP

COPY support for parameters

2019-02-14 Thread Adrian Phinney
Hello, I'm trying to add support for specifying parameters when using a COPY command to Npgsql (.NET's Postgres provider): https://github.com/npgsql/npgsql/pull/2332 I've used the extended query protocol to send the COPY command. When I send a COPY command without parameters, the backend issues t