On Mon, Jan 14, 2013 at 11:28 AM, Stephen Frost <[email protected]> wrote: > * Tom Lane ([email protected]) wrote: >> Stephen Frost <[email protected]> writes: >> > I do like the idea of a generalized answer which just runs a >> > user-provided command on the server but that's always going to require >> > superuser privileges. >> >> The design that was being kicked around allowed pipes to be used on the >> client side too, ie \copy foo to '| gzip ...'. That form would not >> require any special privileges, and might be thought preferable for >> another reason too: it offloads the work from the server. > > It's a different use-case which, imv, is really already trivially > covered: > > psql -c 'COPY foo TO STDOUT;' | gzip > myfile.gz > > While there is no option currently for having the server do the > compression before sending the data over the wire.
+1. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
