* 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.
In response to
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|