Andrew Dunstan <and...@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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to