Re: Possible TODO item: copy to/from pipe

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Andreas Pflug <pgadmin(at)pse-consulting(dot)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