Re: COPY TO STDOUT BINARY - Mailing list pgsql-bugs

From Andreas Pflug
Subject Re: COPY TO STDOUT BINARY
Date
Msg-id 439EFB37.2060301@pse-consulting.de
Whole thread Raw
In response to Re: COPY TO STDOUT BINARY  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: COPY TO STDOUT BINARY
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY TO STDOUT BINARY
Next
From: Tom Lane
Date:
Subject: Re: PQexecParams performance