Wrong COPY command synopsis

From: petr(dot)lancaric(at)seznam(dot)cz
To: pgsql-docs(at)postgresql(dot)org
Subject: Wrong COPY command synopsis
Date: 2017-09-27 11:01:41
Message-ID: 20170927110141.28561.23998@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.1/static/sql-copy.html
Description:

Postgres psql (PostgreSQL) 9.5.4

Wrong COPY command synopsis:

1. comma is not an options separator { ...( option [, ...] ... }
2. FORMAT is not a kewyword {... FORMAT format_name ... }

Following two commands should be valid after synopsis, but they are not:

gis=# COPY gis_entity FROM '/tmp/podl_db_city.csv' DELIMITER ',', FORMAT
csv;
ERROR: syntax error at or near ","
LINE 1: ..._entity FROM '/tmp/podl_db_city.csv' DELIMITER ',', FORMAT c...

^
gis=# COPY gis_entity FROM '/tmp/podl_db_city.csv' DELIMITER ',' FORMAT
csv;
ERROR: syntax error at or near "FORMAT"
LINE 1: ...entity FROM '/tmp/podl_db_city.csv' DELIMITER ',' FORMAT csv...
^

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Peter Eisentraut 2017-09-27 15:38:31 Re: Docbook 5.x
Previous Message David G. Johnston 2017-09-27 02:11:46 Re: "Comparison of Different Solutions"