Stephen Frost <sfrost(at)snowman(dot)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