From: | David Raymond <David(dot)Raymond(at)tomtom(dot)com> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | RE: question about docs on copy command |
Date: | 2019-09-06 13:15:22 |
Message-ID: | VI1PR07MB5792490A57684FC30D82C67D87BA0@VI1PR07MB5792.eurprd07.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
It also appears to be disliking the comma for including more than one option. So something's definitely up with that. But I can't tell you if it's a bug with the program or with the documentation, so hopefully someone else can chime in on that.
(On 11.5 by the way)
mnr=> copy (select 1, 'With space', null) to stdout with null 'NuLL';
1 With space NuLL
mnr=> copy (select 1, 'With space', null) to stdout with delimiter '|';
1|With space|\N
mnr=> copy (select 1, 'With space', null) to stdout with delimiter '|', null 'NuLL';
ERROR: syntax error at or near ","
LINE 1: ..., 'With space', null) to stdout with delimiter '|', null 'Nu...
^
-----Original Message-----
From: Platon Pronko <platon7pronko(at)gmail(dot)com>
Sent: Friday, September 6, 2019 3:47 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: question about docs on copy command
Hi!
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;
However, the error is shown:
> ERROR: syntax error at or near "format"
> LINE 1: copy (select 1) to stdout with format csv;
> ^
This command executes normally:
copy (select 1) to stdout with csv;
Am I missing something, or maybe the docs need a slight correction?
Best regards,
Platon Pronko
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-09-06 14:01:25 | Re: question about docs on copy command |
Previous Message | Platon Pronko | 2019-09-06 07:47:22 | question about docs on copy command |