Postgres Pro
Downloads
Home   >   mailing lists

Re: csv improt to table - Mailing list pgsql-novice

From David G. Johnston
Subject Re: csv improt to table
Date
Msg-id CAKFQuwbwBaqMkC4+2zu0PKEchRoyTD373CSSummrM03d4AOGFw@mail.gmail.com
Whole thread Raw
In response to Re: csv improt to table  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-novice
Tree view
For the list - where does one go (point others) to learn how to read the syntax blocks that are provided in our documentation?

David J.

On Saturday, June 13, 2015, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Saturday, June 13, 2015, Jude DaShiell <jdashiel@panix.com> wrote:
I read the documentation and built a command and tried it and got a syntax error.

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
 
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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: csv improt to table
Next
From: Jude DaShiell
Date:
Subject: Re: import csv file into table