Re: [PATCH] COPY .. COMPRESSED - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [PATCH] COPY .. COMPRESSED
Date
Msg-id 20130115222247.GA27058@momjian.us
Whole thread Raw
In response to Re: [PATCH] COPY .. COMPRESSED  (Stephen Frost <sfrost@snowman.net>)
Responses Re: [PATCH] COPY .. COMPRESSED
List pgsql-hackers
On Tue, Jan 15, 2013 at 04:22:48PM -0500, Stephen Frost wrote:
> * Bruce Momjian (bruce@momjian.us) wrote:
> > Well, COPY is super-user only, so it seems only useful for FDW, no?  We
> > already have lots of user-configuration FDW commands, so I can see
> > adding this one too.
> 
> COPY is most certainly not superuser-only..  COPY w/ popen, if that
> popen can call anything, would certainly have to be superuser-only.

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.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [PATCH] COPY .. COMPRESSED
Next
From: Stephen Frost
Date:
Subject: Re: [PATCH] COPY .. COMPRESSED