Re: [HACKERS] Binary mode copy in from stdin

2007-06-09 Thread Tom Lane
"Dann Corbit" <[EMAIL PROTECTED]> 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 ---(end of broadcast)-

[HACKERS] Binary mode copy in from stdin

2007-06-08 Thread Dann Corbit
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 fro