Re: CSV import - Mailing list pgsql-sql

From Rodger Donaldson
Subject Re: CSV import
Date
Msg-id E18difQ-0004mk-00@israel.diaspora.gen.nz
Whole thread Raw
In response to CSV import  (Oliver Vecernik <vecernik@aon.at>)
List pgsql-sql
> --- Oliver Vecernik <vecernik@aon.at> wrote:
> > Is there a direct way to import such files into
> > PostgreSQL?
> > 
> 
> As I believe others have replied: no, not yet.
> 
> Otherwise, parsing CSV
> files gets just too complicated, and you are better
> off using an existing solution (like a Perl module) to
> preprocess your data.

The DBD::CSV module allows one to use a subset of SQL syntax on CSV 
files, as an example.  Docs are at 
http://search.cpan.org/author/JZUCKER/DBD-CSV-0.2002/lib/DBD/CSV.pm

-- 
Rodger Donaldson
rodgerd@diaspora.gen.nz


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: LONG - Question on dealing w/ numerics
Next
From: Tom Lane
Date:
Subject: Re: LONG - Question on dealing w/ numerics