Is COPY foo TO STDOUT BINARY supposed to work? The query will run some
time, but won't give a result.

I couldn't see any mentioning in the COPY command docs that would
prohibit use of this combination.

Tested with psql on 8.0.5 and 8.1.1.

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Andreas Pflug <pgadmin (AT) pse-consulting (DOT) de> writes:
I don't think psql will do anything particularly sane with binary copy
data, if that's what you meant.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Tom Lane wrote:
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