Re: copy syntax

Поиск
Список
Период
Сортировка
От Guillaume Lelarge
Тема Re: copy syntax
Дата
Msg-id 1333569866.2315.62.camel@localhost.localdomain
обсуждение исходный текст
Ответ на copy syntax  (Andy Chambers <achambers@mcna.net>)
Список 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 по дате отправления: