* Bruce Momjian (bruce(at)momjian(dot)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