From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: sfbarbee@gmail.com
Subject: HEADER [ boolean ] not allowed in COPY ... FROM statement
Date: Fri, 22 Feb 2019 07:50:03 +0000
Message-ID: <155082180372.1363.9996740407258989599@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-copy.html
Description:
> psql --version ;
psql (PostgreSQL) 11.2
> initdb --version ;
initdb (PostgreSQL) 11.2
The boolean parameter is not allowed in the statement:
# COPY table_name FROM '/srv/database/pg_dumps/file.csv' WITH CSV HEADER
true DELIMITER ',' QUOTE '"' ;
ERROR: syntax error at or near "true"
LINE 1: ...pg_dumps/file.csv' WITH CSV HEADER true DELIM...
# COPY table_name FROM '/srv/database/pg_dumps/file.csv' WITH CSV HEADER
'true' DELIMITER ',' QUOTE '"' ;
ERROR: syntax error at or near "'true'"
LINE 1: ...pg_dumps/file.csv' WITH CSV HEADER 'true' DEL...
^
# COPY table_name FROM '/srv/database/pg_dumps/file.csv' WITH CSV HEADER 1
DELIMITER ',' QUOTE '"' ;
ERROR: syntax error at or near "1"
LINE 1: ...pg_dumps/file.csv' WITH CSV HEADER 1 DELIMITE...
# COPY table_name FROM '/srv/database/pg_dumps/file.csv' WITH CSV HEADER
DELIMITER ',' QUOTE '"' ;
COPY 63
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, sfbarbee@gmail.com
Subject: Re: HEADER [ boolean ] not allowed in COPY ... FROM statement
In-Reply-To: <155082180372.1363.9996740407258989599@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox