Tom Lane wrote:
> Andreas Pflug <pgadmin(at)pse-consulting(dot)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