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