Indeed, my eyes completely ignored all the punctuation or pattern characters. Thank you!
Best regards,
Platon Pronko
On 2019-09-06 17:01, Tom Lane wrote:
> Platon Pronko <platon7pronko@gmail.com> writes:
>> I'm having a little trouble with docs of COPY command: https://www.postgresql.org/docs/11/sql-copy.html
>
>> Excerpt from synopsis:
>
>>> COPY { table_name [ ( column_name [, ...] ) ] | ( query ) }
>>> TO { 'filename' | PROGRAM 'command' | STDOUT }
>>> [ [ WITH ] ( option [, ...] ) ]
>>>
>>> where option can be one of:
>>>
>>> FORMAT format_name
>
>> This led me to beleive that the following command should be valid:
>
>> copy (select 1) to stdout with format csv;
>
> You missed the parentheses. This works:
>
> regression=# copy (select 1) to stdout with (format csv);
> 1
>
> It does require a bit of attention to tell the metacharacters (braces
> and square brackets) from the literal punctuation :-(
>
>> This command executes normally:
>> copy (select 1) to stdout with csv;
>
> IIRC, that's valid per the "old syntax" described near the end of the
> page. The new syntax uses parens.
>
> regards, tom lane
>