Re: Possible TODO item: copy to/from pipe

Andreas Pflug <pgadmin@pse-consulting.de> writes:
> My COPY WITH COMPRESSION is not the same as taking a copy file and 
> zipping it; it creates a copy file with BinarySignature that has 
> compressed bytes in the data part, thus it can be handled by any client 
> app that can stream binary copy files from/to the server.

If you mean you're compressing each data field separately, that's surely
a very bad idea.  If you mean you're compressing everything except the
file header, I fail to see the value.  Binary is binary.  I *seriously*
doubt there are clients out there that look for a PGCOPY header before
deciding whether to send the file to the server or not.  And a client
that did know that much about a PGCOPY file would likely spit up on a
critical flag it didn't recognize, anyway.
        regards, tom lane