Jim C. Nasby wrote:
>While I'm all for COPY from views, I think I'd rather have the syntactic
>warts than code warts. ISTM that
>
>CREATE TEMP VIEW some_name AS SELECT * FROM table WHERE ...;
>COPY some_name TO stdout;
>
>is much uglier than
>
>COPY SELECT * FROM table WHERE ... TO stdout;
>
>
They aren't mutually exclusive, though. And once you have code in place
for the first part, turning the direct query case into a temp_view+copy
is arguably just a case of syntactic sugar. I do think the direct query
should at least be parenthesized, if we go that way.
So why not do what everyone is agreed on now? Whatever happens the work
won't be wasted.
Also, as nifty as this might be, we should also be prepared for people
to complain that it runs a lot slower than vanilla COPY, because it
surely will.
cheers
andrew