Skip site navigation (1) Skip section navigation (2)

Re: [PATCH] COPY .. COMPRESSED

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: Christopher Browne <cbbrowne(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] COPY .. COMPRESSED
Date: 2013-01-15 22:22:47
Message-ID: 20130115222247.GA27058@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Jan 15, 2013 at 04:22:48PM -0500, Stephen Frost wrote:
> * Bruce Momjian (bruce(at)momjian(dot)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(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


In response to

Responses

pgsql-hackers by date

Next:From: Stephen FrostDate: 2013-01-15 22:24:37
Subject: Re: [PATCH] COPY .. COMPRESSED
Previous:From: Stephen FrostDate: 2013-01-15 22:19:58
Subject: Re: [PATCH] COPY .. COMPRESSED

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group