Tom Lane wrote:
Andreas Pflug <[EMAIL PROTECTED]> writes:
Is COPY foo TO STDOUT BINARY supposed to work?
I don't think psql will do anything particularly sane with binary copy
data, if that's what you meant.
echo "COPY foo TO STDOUT BINARY;" | psql >bar
writes a 0 bytes file; not surprised if psql doesn't act sanely in
interactive mode.
For testing, I changed slony to use COPY .. BINARY, same result.
Regards,
Andreas
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend