* Bruce Momjian (br...@momjian.us) wrote: > COPY with a file name is super-user-only. I am unclear how you would > use STDIN/STDOUT in any meaningful way with binary data produced by > compression. I guess you could with libpq.
The patch that I posted provided this: psql -h myhost -c "COPY mytable FROM STDIN COMPRESSED;" < myfile.gz With the compressed file being transferred unmolested to the server side where it was decompressed and processed by the server. Thanks, Stephen
signature.asc
Description: Digital signature