Andrew Dunstan <andrew@dunslane.net> writes:
> Yeah, I agree, although the syntax looks a bit unclean.
Oh, I had not looked at the syntax closely. I agree, that basically
sucks: it's overcomplicated and under-featured, because you can't
control the actual program command line very conveniently. Nor do I see
a reason to force this into the model of "program filtering a specific
file". What happened to the previous proposal of treating the COPY
target as a pipe specification, ie
COPY table FROM 'some command line |';COPY table TO '| some command line';
> Not sure what we'd do for \copy though.
Adding a pipe symbol to the target works exactly the same for \copy.
regards, tom lane