Re: [BUGS] COPY TO STDOUT BINARY

2005-12-30 Thread Bruce Momjian
Andreas Pflug wrote: > Tom Lane wrote: > > Andreas Pflug <[EMAIL PROTECTED]> 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;

Re: [BUGS] COPY TO STDOUT BINARY

2005-12-13 Thread Andreas Pflug
Tom Lane wrote: Andreas Pflug <[EMAIL PROTECTED]> 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 surprise

Re: [BUGS] COPY TO STDOUT BINARY

2005-12-13 Thread Tom Lane
Andreas Pflug <[EMAIL PROTECTED]> 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. regards, tom lane ---(end of broadcast)---

[BUGS] COPY TO STDOUT BINARY

2005-12-13 Thread Andreas Pflug
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