Re: csv improt to table
| От | David G. Johnston |
|---|---|
| Тема | Re: csv improt to table |
| Дата | |
| Msg-id | CAKFQuwaR0ukFkp_3Q9G0PoHmaZKy=+Nf0x-C7rLY=e=AQE61oQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: csv improt to table (Jude DaShiell <jdashiel@panix.com>) |
| Ответы |
Re: csv improt to table
|
| Список | pgsql-novice |
On Saturday, June 13, 2015, Jude DaShiell <jdashiel@panix.com> wrote:
Re-read the syntax and examples on this page. Your first problem, as noted by the error message, is that the word "to" does not immediately follow the word copy.
http://www.postgresql.org/docs/9.4/interactive/sql-copy.html
I read the documentation and built a command and tried it and got a syntax error.
http://www.postgresql.org/docs/9.4/interactive/sql-copy.html
Before I ran the command, I changed all single quotes in the csv file to double quotes. I copied the command and the generated error onto my clipboard so what follows is a paste into this message.
Cut here.
copy to health /home/jude/health.csv format csv header force-not-null;
ERROR: syntax error at or near "to"
LINE 1: copy to health /home/jude/health.csv format csv header force...
David J.
В списке pgsql-novice по дате отправления: