Binary mode copy in from stdin

Started by Dann Corbitover 18 years ago2 messages
#1Dann Corbit
DCorbit@connx.com

We have (among other things) and ODBC/OLEDB/JDBC/.NET driver for
PostgreSQL and we want to optimize fast mode insert/select behavior.

When we try to do a binary mode copy from standard input, we get an
error message that we can't do it.

How can we programmatically insert data using COPY from our own data
stream without creating a file.

In our case, creating a file is just plain stupid. There is never any
reason for the data to hit the disk except at write time.

In case you were wondering, we already have the data in the correct
binary format.

Why was it decided that binary mode is not allowed for stdin or stdout?
After all, programs can pipe to stdin and stdout.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Dann Corbit (#1)
Re: Binary mode copy in from stdin

"Dann Corbit" <DCorbit@connx.com> writes:

Why was it decided that binary mode is not allowed for stdin or stdout?

Works fine when using V3 frontend protocol. The old protocol for it
isn't 8-bit-clean.

regards, tom lane