Re: import csv file into table

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(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Subject: Re: import csv file into table
Date: 2015-06-13 13:55:42
Message-ID: CAP6d-HUrFWBpL7DrzbYzNCQRq32DAZDe-VP9VfsgKsR3FdxrXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

--
Michael Wood

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jude DaShiell 2015-06-13 20:20:42 Re: import csv file into table
Previous Message David G. Johnston 2015-06-13 13:24:55 Re: import csv file into table