About COPY
От | Andrés Repossi |
---|---|
Тема | About COPY |
Дата | |
Msg-id | 00d301c2dc13$f3cbbc20$7c02020a@c1.pjn.gov.ar обсуждение исходный текст |
Список | pgadmin-support |
copy tfal from 'C:\\tfal.txt' using delimiter '|'
Te error message is: ERROR: parser: parse error at or near "delimiter"
The tfal.txt has only one row, and the format of the row is:
5|M|118 |BELLAFRONTE|LUIS|0|0|0|1996|9|15|818 |2 |54 |1996|B|||1996|11|1|0|02/04/2003|
and, the schema of the table is: CREATE tfal_dni int4 NOT NULL, tfal_sexo char(1) NOT NULL, tfal_ofisec char(4), tfal_ape varchar(35), tfal_nom varchar(35), tfal_anionac int2, tfal_mesnac int2, tfal_dianac int2, tfal_aniofal int2, tfal_mesfal int2, tfal_diafal int2, tfal_acta char(5), tfal_tomo char(5), tfal_folio char(4), tfal_anioi int2, tfal_provfal char(1), tfal_dptofal char(2), tfal_localfal varchar(30), tfal_anioing int2, tfal_mesing int2, tfal_diaing int2, tfal_fechaps int4, tfal_fechacarga date, ) WITH OIDS;
В списке pgadmin-support по дате отправления: