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 ]
'nullstring' ] ]
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.