Re: [PATCH] COPY .. COMPRESSED

* Peter Eisentraut (peter_e@gmx.net) wrote:
> On 1/15/13 2:53 PM, Stephen Frost wrote:
> > You're right, to clarify, for *file_fdw*, which is a backend-only
> > operation, the popen patch is great (thought I made that clear before).
>
> I would think that if we get writable FDWs, you would want file_fdw to
> go through zlib so that it can write directly to the file.

With the popen patch, I expect it could be defined as '|gzip >
myfile.gz'..  I believe that patch did that.  It'd be ideal to add
support for that to file_fdw also, certainly.  That shouldn't be hard as
file_fdw is essentially a wrapper around backend COPY already and this
would just be adding a few additional options to pass through.
Thanks,
    Stephen