Re: csv improt to table

From: Jude DaShiell <jdashiel(at)panix(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: csv improt to table
Date: 2015-06-13 22:57:31
Message-ID: alpine.NEB.2.11.1506131851260.14714@panix1.panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I read the documentation and built a command and tried it and got a syntax
error.
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...

I could have left out force-not-null but decided to try it and I am rather
certain that last command parameter is not the reason for this syntax
error.

--

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message David G. Johnston 2015-06-13 23:56:18 Re: csv improt to table
Previous Message Jude DaShiell 2015-06-13 20:20:42 Re: import csv file into table