Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id A938A477203
	for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 18:50:36 -0500 (EST)
Received: from web20809.mail.yahoo.com (web20809.mail.yahoo.com
	[216.136.226.198])
	by postgresql.org (Postfix) with SMTP id 34BC44770B9
	for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 17:45:32 -0500 (EST)
Message-ID: <20030128224533.71751.qmail@web20809.mail.yahoo.com>
Received: from [208.13.35.65] by web20809.mail.yahoo.com via HTTP;
	Tue, 28 Jan 2003 14:45:33 PST
Date: Tue, 28 Jan 2003 14:45:33 -0800 (PST)
From: Jeff Eckermann <jeff_eckermann@yahoo.com>
Subject: Re: CSV import
To: Oliver Vecernik <vecernik@aon.at>,
	pgsql-sql <pgsql-sql@postgresql.org>
In-Reply-To: <3E3697AF.2030509@aon.at>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/445
X-Sequence-Number: 11310

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

If you are absolutely sure that your data will _never_
contain commas, then the simple solution of just
deleting all of the quotes , then using COPY with
comma delimiters, will work.  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.

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com