Re: copy syntax - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: copy syntax
Date
Msg-id 1333569866.2315.62.camel@localhost.localdomain
Whole thread Raw
In response to copy syntax  (Andy Chambers <achambers@mcna.net>)
List pgsql-general
On Wed, 2012-04-04 at 16:01 -0400, Andy Chambers wrote:
> dcm_eob=> copy ar_data from '/tmp/ar-data.csv' with header true;
> ERROR:  syntax error at or near "true"
> LINE 1: copy ar_data from '/tmp/ar-data.csv' with header true;
>
> I can't figure out what's wrong with the syntax above.  Is something missing?
>

Yes, you need parentheses, like this:

copy ar_data from '/tmp/ar-data.csv' with (header true);


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


pgsql-general by date:

Previous
From: Andy Chambers
Date:
Subject: copy syntax
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: Leaky Perl / DBIx / Postgres 9.0.1 Trio