SQL copy from csv with explicit field ordering
От | Terry Fielder |
---|---|
Тема | SQL copy from csv with explicit field ordering |
Дата | |
Msg-id | 3A9EB50E.C2770BEA@greatgulfhomes.com обсуждение исходный текст |
Ответы |
Re: SQL copy from csv with explicit field ordering
|
Список | pgsql-sql |
I guess this is really a SQL question: I have a csv that I want to import, but the csv has different column ordering. I have tried putting the column names in the first row, but then the copy command fails on field which is data type (eg it is seeing the cells in first row as data, not header info). ggtest=> copy ap_trans from '/var/dbase/ap_trans.csv' using delimiters ','; ERROR: pg_atoi: error in "id": can't parse "id" The help indicates: ggtest=> \h copy Command: copy Description: copy data to and from a table Syntax: COPY [BINARY] class_name [WITH OIDS] TO|FROM filename|STDIN|STDOUT [USING DELIMITERS 'delim']; I have tried WITH OIDS but with same results. Is there somewhere that I can either enable the first line of CSV as header names OR Can I explicitly define my import field ordering from within the select statement? Thanks Terry Fielder terry@greatgulfhomes.com
В списке pgsql-sql по дате отправления: