Skip site navigation (1) Skip section navigation (2)

Re: BUG #6527: Error in COPY documentation syntax

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: samuel(dot)gilbert(at)ec(dot)gc(dot)ca
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6527: Error in COPY documentation syntax
Date: 2012-03-13 07:55:18
Message-ID: 1331625318.2293.7.camel@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On Mon, 2012-03-12 at 19:34 +0000, samuel(dot)gilbert(at)ec(dot)gc(dot)ca wrote:
> The following bug has been logged on the website:
> Bug reference:      6527
> Logged by:          Samuel Gilbert
> Email address:      samuel(dot)gilbert(at)ec(dot)gc(dot)ca
> PostgreSQL version: 9.0.4
> Operating system:   Linux
> Description:        
> There is an error in the syntax of the COPY statement in the documentation
> for versions 9.0.x and 9.1.x.  I tested on 9.0.4 and 9.1.3.
> According to the documentation, given the table exists and is compatible
> with the CSV file, the following statement should work :
> COPY improve_station FROM '/local/improve.csv' FORMAT CSV HEADER TRUE;

No, it shouldn't work. You forgot parentheses, and commas. This should

COPY improve_station FROM '/local/improve.csv' (FORMAT CSV, HEADER

> However, it doesn't work.  Instead I get the following error :
> ERROR:  syntax error at or near "FORMAT"
> LINE 1: ...ns FROM '/local/improve.csv' FORMAT CSV...
>                                         ^
> After trying a few trials and errors, I managed to find that ommiting FORMAT
> gave me another error instead :
> COPY improve_stations FROM '/local/improve.csv' CSV HEADER TRUE;
> ERROR:  syntax error at or near "TRUE"
> LINE 1: ...M '/local/improve.csv' CSV HEADER TRUE;
>                                              ^
> Removing the boolean value (TRUE) actually works.  This means that there are
> at least two errors in the syntax specification in the documentation.
> Instead of "FORMAT format_name", it should be "[ TEXT | CSV | BINARY ]" and
> "HEADER [ boolean ]" should be "[ HEADER ]".

No error, and no bug. The documentation says (even if it's hard to see)
that you need parentheses and commas. The examples show it too.


In response to

pgsql-bugs by date

Next:From: stuart.bishopDate: 2012-03-13 09:00:18
Subject: BUG #6528: pglesslog still referenced in docs, but no 9.1 support
Previous:From: Sergey BurladyanDate: 2012-03-12 21:10:42
Subject: Re: BUG #6480: NLS text width problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group