Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Wood
Subject Re: import csv file into table
Date
Msg-id CAP6d-HUrFWBpL7DrzbYzNCQRq32DAZDe-VP9VfsgKsR3FdxrXQ@mail.gmail.com
Whole thread Raw
In response to Re: import csv file into table  (Jude DaShiell <jdashiel@panix.com>)
Responses Re: import csv file into table
List pgsql-novice
Tree view

Hi

On 13 Jun 2015 1:01 PM, "Jude DaShiell" <jdashiel@panix.com> wrote:
>
> I can remove the single quotes from beginning and ends of all records easily.  Do the single quotes need to be removed from around all fields or just from the beginnings and ends of records?  I have no comas inside of fields in the file.  The file first came from emacs-orgmode then was edited to create the csv file.

(Sorry for any mangled quoting. Replying from my phone.)

It would help a lot if you provided a representative line from the csv file.

--
Michael Wood

pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: import csv file into table
Next
From: learnnewtech2015
Date:
Subject: PostgreSQL GUI Tool with GIT repository integration