Skip site navigation (1) Skip section navigation (2)

About COPY

From: Andrés Repossi <andres(dot)repossi(at)c1(dot)pjn(dot)gov(dot)ar>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: About COPY
Date: 2003-02-24 14:49:36
Message-ID: 00d301c2dc13$f3cbbc20$7c02020a@c1.pjn.gov.ar (view raw or flat)
Thread:
Lists: pgadmin-support
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

pgadmin-support by date

Next:From: Dave PageDate: 2003-02-24 15:02:41
Subject: Re: About COPY
Previous:From: Erwin BrandstetterDate: 2003-02-24 04:40:21
Subject: Re: Bug in Migration Wizard 2.4.12 with 1-1 relationships

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group