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.1506131620080.25464@panix3.panix.com
Whole thread Raw
In response to Re: import csv file into table  (Michael Wood <esiotrot@gmail.com>)
List pgsql-novice
Not a problem.

'2014-05-19','116','68','64','93'
On Sat, 13 Jun 2015, Michael Wood wrote:

> Date: Sat, 13 Jun 2015 09:55:42
> From: Michael Wood <esiotrot@gmail.com>
> To: Jude DaShiell <jdashiel@panix.com>
> Cc: PostgreSQL List - Novice <pgsql-novice@postgresql.org>,
>     David G. Johnston <david.g.johnston@gmail.com>
> Subject: Re: [NOVICE] import csv file into table
>
> 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.
>
>

--



pgsql-novice by date:

Previous
From: learnnewtech2015
Date:
Subject: PostgreSQL GUI Tool with GIT repository integration
Next
From: Jude DaShiell
Date:
Subject: Re: csv improt to table