Re: COPY TO STDOUT BINARY

Tom Lane wrote:
> Andreas Pflug <pgadmin@pse-consulting.de> 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