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