Re: import csv file into table

From: Jude DaShiell <jdashiel(at)panix(dot)com>
To: Michael Wood <esiotrot(at)gmail(dot)com>
Cc: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Subject: Re: import csv file into table
Date: 2015-06-13 20:20:42
Message-ID: alpine.NEB.2.11.1506131620080.25464@panix3.panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)com>
> To: Jude DaShiell <jdashiel(at)panix(dot)com>
> Cc: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>,
> David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
> Subject: Re: [NOVICE] import csv file into table
>
> Hi
>
> On 13 Jun 2015 1:01 PM, "Jude DaShiell" <jdashiel(at)panix(dot)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.
>
>

--

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jude DaShiell 2015-06-13 22:57:31 Re: csv improt to table
Previous Message Michael Wood 2015-06-13 13:55:42 Re: import csv file into table