* 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

In response to

• Re: [PATCH] COPY .. COMPRESSED at 2013-01-15 22:22:47 from Bruce Momjian

pgsql-hackers by date

Next:	From: Kohei KaiGai	Date: 2013-01-15 22:28:40
	Subject: Re: Review of Row Level Security
Previous:	From: Bruce Momjian	Date: 2013-01-15 22:22:47
	Subject: Re: [PATCH] COPY .. COMPRESSED