[pgadmin-support] About COPY

[Andrés Repossi]

Hi, I'm new working with PostgreSQL, and I'm trying to load an ascii text file to a table using the command copy but it throws me an error message that it can't parse the line, and I don't really don't know why is this hapening.   The sentence that I'm using is this: 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 TABLE tfal ( 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, CONSTRAINT tfal_pkey PRIMARY KEY (tfal_dni, tfal_sexo) ) WITH OIDS; Does anyone had a trouble like this?, I don't understand what am I doing wrong. The version of the PGAdmin II I'm using is 1.4.12.   Could anyone lend me a hand please, thanks,     Andrés