COPY command - CSV files
От | Umberto Zappi |
---|---|
Тема | COPY command - CSV files |
Дата | |
Msg-id | 40950DC7.4070609@inwind.it обсуждение исходный текст |
Ответы |
Re: COPY command - CSV files
Re: COPY command - CSV files Re: COPY command - CSV files Re: COPY command - CSV files Re: COPY command - CSV files |
Список | 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 ] '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.
В списке pgsql-hackers по дате отправления: