Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group