Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 2C07E4769B7
	for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 09:50:03 -0500 (EST)
Received: from email06.aon.at (WARSL401PIP3.highway.telekom.at [195.3.96.75])
	by postgresql.org (Postfix) with SMTP id 3A609476975
	for <pgsql-sql@postgresql.org>; Tue, 28 Jan 2003 09:50:02 -0500 (EST)
Received: (qmail 438542 invoked from network); 28 Jan 2003 14:50:05 -0000
Received: from m214p017.dipool.highway.telekom.at (HELO aon.at)
	([62.46.16.177]) (envelope-sender <vecernik@aon.at>)
	by qmail6rs.highway.telekom.at (qmail-ldap-1.03) with SMTP
	for <pgsql-sql@postgresql.org>; 28 Jan 2003 14:50:05 -0000
Message-ID: <3E3697AF.2030509@aon.at>
Date: Tue, 28 Jan 2003 15:46:07 +0100
From: Oliver Vecernik <vecernik@aon.at>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-AT;
	rv:1.0.0) Gecko/20020623 Debian/1.0.0-0.woody.1
X-Accept-Language: de, de-de
MIME-Version: 1.0
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: CSV import
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/436
X-Sequence-Number: 11301

Hi again!

After investigating a little bit further my CSV import couldn't work 
because of following reasons:

1. CSV files are delimited with CR/LF
2. text fields are surrounded by double quotes

Is there a direct way to import such files into PostgreSQL?

I would like to have something like MySQL provides:

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
    [REPLACE | IGNORE]
    INTO TABLE tbl_name
    [FIELDS
        [TERMINATED BY '\t']
        [[OPTIONALLY] ENCLOSED BY '']
        [ESCAPED BY '\\' ]
    ]
    [LINES TERMINATED BY '\n']
    [IGNORE number LINES]
    [(col_name,...)]

Has anybody written such a function already?

Regards,
Oliver

-- 
VECERNIK Datenerfassungssysteme
A-2560 Hernstein, Hofkogelgasse 17
Tel.: +43 2633 47530, Fax: DW 50
http://members.aon.at/vecernik