COPY binary

Started by Nathanielover 16 years ago2 messagesgeneral
Jump to latest
#1Nathaniel
naptrel@yahoo.co.uk

Hello,

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

Nathaniel

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Nathaniel (#1)
Re: COPY binary

Nathaniel <naptrel@yahoo.co.uk> writes:

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

Yes.

regards, tom lane