| 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: | Whole Thread | Raw Message | 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.
>
>
--
| 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 |