Re: [PATCH] COPY .. COMPRESSED

* Bruce Momjian (bruce@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