Andreas Pflug <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings