Tom Lane wrote:
> There was a proposal awhile back to provide a variant of \copy
> that works more like \g, so you'd enter something like
>
> COPY (SELECT ...) TO STDOUT
> \copyto somefile
>
> which'd be way more flexible --- the COPY command wouldn't have to
> fit on one line, for one thing. But I don't think that's gone
> anywhere yet.
That would be the proof-of-concept patch posted a few weeks ago here:
https://www.postgresql.org/message-id/15dadc39-e050-4d46-956b-dcc4ed098753@manitou-mail.org
There didn't seem to be much of community buy-in for this idea, so I've it
let rest
for the moment. On one hand, it solves actual problems such as the one
mentioned in this bug report, on the other hand I can feel the discomfort
of having 3 forms of \copy, in addition to COPY, and that maybe it would
create more confusion than benefits, overall.
Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite