Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 763E74770E1
	for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 23:13:27 -0500 (EST)
Received: from israel.diaspora.gen.nz (israel.diaspora.gen.nz [202.50.109.65])
	by postgresql.org (Postfix) with ESMTP id 40EB2478A2C
	for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 22:13:40 -0500 (EST)
Received: from www-data by israel.diaspora.gen.nz with local (Exim 3.35 #1
	(Debian)) id 18difQ-0004mk-00; Wed, 29 Jan 2003 16:13:36 +1300
From: "Rodger Donaldson" <rodgerd@diaspora.gen.nz>
To: Jeff Eckermann <jeff_eckermann@yahoo.com>,
	Oliver Vecernik <vecernik@aon.at>, pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: CSV import
X-Mailer: NeoMail 1.14
X-IPAddress: 202.49.97.73
MIME-Version: 1.0
Message-Id: <E18difQ-0004mk-00@israel.diaspora.gen.nz>
Date: Wed, 29 Jan 2003 16:13:36 +1300
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/456
X-Sequence-Number: 11321

> --- 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