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