Re: [PATCH] COPY .. COMPRESSED
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stephen Frost <sfrost@snowman.net>
Cc: Simon Riggs <simon@2ndQuadrant.com>, pgsql-hackers@postgresql.org
Date: 2013-01-14T16:13:17Z
Lists: pgsql-hackers
Stephen Frost <sfrost@snowman.net> 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. regards, tom lane