Postgres Pro
Downloads
Home   >   mailing lists

Re: import csv file into table - Mailing list pgsql-novice

From Jude DaShiell
Subject Re: import csv file into table
Date
Msg-id alpine.NEB.2.11.1506132118180.23405@panix2.panix.com
Whole thread Raw
In response to import csv file into table  (Jude DaShiell <jdashiel@panix.com>)
List pgsql-novice
Tree view 
SOLVED!  What worked was:
\COPY health FROM health.csv WITH csv DELIMITER ',' QUOTE '"'

I think I ended all of that with a semicolon but psql didn't complain.
Thanks much for your interest assistance and listening.



--

pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: csv improt to table
Next
From: Bianca Stephani
Date:
Subject: Update taking forever