Re: COPY TO STDOUT BINARY

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: COPY TO STDOUT BINARY
Date: 2005-12-13 16:47:51
Message-ID: 439EFB37.2060301@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-12-13 18:26:08 Re: PQexecParams performance
Previous Message Tom Lane 2005-12-13 15:42:43 Re: COPY TO STDOUT BINARY