Re: COPY table FROM STDIN via SPI - Mailing list pgsql-hackers

From Joe Conway
Subject Re: COPY table FROM STDIN via SPI
Date
Msg-id 7c3f99c2-1b64-0e4f-c7c0-1a27e438ea18@joeconway.com
Whole thread Raw
In response to Re: COPY table FROM STDIN via SPI  (chap@anastigmatix.net)
List pgsql-hackers
On 7/12/23 14:43, chap@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




pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: logical decoding and replication of sequences, take 2
Next
From: Robert Haas
Date:
Subject: Re: 'ERROR: attempted to update invisible tuple' from 'ALTER INDEX ... ATTACH PARTITION' on parent index