On 7/12/23 14:43, c...@anastigmatix.net wrote:
On 2023-07-12 14:18, Joe Conway wrote:
On 7/11/23 22:52, James Sewell wrote:
What about running a COPY directly from C - is that possible?
https://www.postgresql.org/docs/current/libpq-copy.html
Or is the question about a COPY kicked off from server-side
C code (following up a question about SPI)?
If the idea is to kick off a COPY that reads from the connected
client's STDIN, the wire protocol doesn't really have a way to
work that out with the client, as Tom pointed out.
Or is the goal for some server-side code to quickly populate
a table from some file that's readable on the server and has
the same format that COPY FROM expects?
You can still use this in a server-side extension in the same way that
dblink works. Perhaps ugly, but I have used it in the past and it worked
*really* well for us.
--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
