* Bruce Momjian ([email protected]) 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
