Thread: COPY binary

COPY binary

From

Nathaniel

Date:

17 September 2009, 16:11:35

Hello,

When using PQputCopyData and PQgetCopyData to send and receive binary data from postgres, would you include/expect
headersand trailers (as well as the tuples themselves) as you would in a binary file named 'file_name' if you were
executingthe SQL "COPY BINARY table_name FROM/TO 'file_name'"? 

Nathaniel

Re: COPY binary

From

Tom Lane

Date:

17 September 2009, 16:25:16

Nathaniel <naptrel@yahoo.co.uk> writes:
> When using PQputCopyData and PQgetCopyData to send and receive binary data from postgres, would you include/expect
headersand trailers (as well as the tuples themselves) as you would in a binary file named 'file_name' if you were
executingthe SQL "COPY BINARY table_name FROM/TO 'file_name'"? 

Yes.

            regards, tom lane