Re: CSV import - Mailing list pgsql-sql

From Jeff Eckermann
Subject Re: CSV import
Date
Msg-id 20030128224533.71751.qmail@web20809.mail.yahoo.com
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.

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


pgsql-sql by date:

Previous
From: Guy Fraser
Date:
Subject: Re: converting microsoft sql server 2000 sql-code for postgresql
Next
From: Jeff Eckermann
Date:
Subject: Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1