From: Rodger Donaldson <rodgerd@diaspora.gen.nz>
To: Jeff Eckermann <jeff_eckermann@yahoo.com>
To: Oliver Vecernik <vecernik@aon.at>
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: CSV import
Date: Wed, 29 Jan 2003 16:13:36 +1300
Message-ID: <E18difQ-0004mk-00@israel.diaspora.gen.nz> (raw)
> --- 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rodgerd@diaspora.gen.nz, jeff_eckermann@yahoo.com, vecernik@aon.at
Subject: Re: CSV import
In-Reply-To: <E18difQ-0004mk-00@israel.diaspora.gen.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox