Re: COPY table FROM STDIN via SPI

On 7/12/23 14:43, chap(at)anastigmatix(dot)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