Re: Allow COPY to use parameters - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: Allow COPY to use parameters
Date
Msg-id 8737p7kt0g.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: Allow COPY to use parameters  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
>>>>> "Merlin" == Merlin Moncure <mmoncure@gmail.com> writes:
Merlin> Hm, what's the use case preparing COPY?

Preparing it isn't necessarily the point (and SQL-level PREPARE is not
addressed in that patch). The point is to allow parameters, so that a
client can do

COPY (select blah from whatever where thing = $1) TO ...

without having to mess around with interpolations.
Merlin> Note, the biggest pain point I have with COPY is not being ableMerlin> to parameterize the filename argument.

Certainly that can be handled too.

-- 
Andrew (irc:RhodiumToad)



pgsql-hackers by date:

Previous
From: ilmari@ilmari.org (Dagfinn Ilmari Mannsåker)
Date:
Subject: Re: To-Do item: skip table scan for adding column with provable check constraints
Next
From: Jeff Janes
Date:
Subject: Re: effective_io_concurrency in 9.6beta