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,
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,
pgadmin-support by date
|Next:||From: Dave Page||Date: 2003-02-24 15:02:41|
|Subject: Re: About COPY|
|Previous:||From: Erwin Brandstetter||Date: 2003-02-24 04:40:21|
|Subject: Re: Bug in Migration Wizard 2.4.12 with 1-1 relationships|