COPY command - CSV files

From: Umberto Zappi <uzappi(at)inwind(dot)it>
To: pgsql-hackers(at)postgresql(dot)org
Subject: COPY command - CSV files
Date: 2004-05-02 15:03:35
Message-ID: 40950DC7.4070609@inwind.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wish modify COPY command for support of CSV files (dump/load files in
CSV format).
I think this option is very important from import data from spreedsheet
as OpenOffice/calc or M$/excel.
I have found this task in TODO list, also.

I've begin my work, modify COPY syntax in:

COPY tablename [ ( column [, ...] ) ]
FROM { 'filename' | STDIN }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[ [ OPTIONALLY ] ENCLOSED [ BY ] 'delimiter1' [ AND
'delimiter2' ] ]
[ NULL [ AS ] 'null string' ] ]

COPY tablename [ ( column [, ...] ) ]
TO { 'filename' | STDOUT }
[ [ WITH ]
[ BINARY ]
[ OIDS ]
[ DELIMITER [ AS ] 'delimiter' ]
[ ENCLOSED [ BY ] 'delimiter1' [ AND 'delimiter2' ] ]
[ NULL [ AS ] 'null string' ] ]

Syntax is like to control-file of Oracle's utility sql*load.
Enclosed define the first and second delimiters (if are different)
which surround each field.
The delimiters may be optionally if keyword exists.

At soon!
Umberto Zappi.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-05-02 15:10:44 Re: Fixed directory locations in installs
Previous Message Fabien COELHO 2004-05-02 15:02:40 Re: pgsql-server/src backend/utils/adt/acl.c inclu ...