Postgres Pro
Downloads
Home   >   mailing lists

Syntax error in a large COPY - Mailing list pgsql-general

From Reg Me Please
Subject Syntax error in a large COPY
Date
Msg-id 200711061905.52914.regmeplease@gmail.com
Whole thread Raw
Responses Re: Syntax error in a large COPY  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Syntax error in a large COPY  (Reg Me Please <regmeplease@gmail.com>)
List pgsql-general
Tree view 
Hi all.
I'm generating an SQL script to load some million rows into a table.
I'm trying to use the COPY command in order to speed the load up.

At a certain point I get an error telling about a
"invalid input syntax for type numeric"

The incriminated line number is the last one (the one containing the \.).

Is there a way to know which line is really malformed?

Thanks.

--
Reg me Please

pgsql-general by date:

Previous
From: Christian Schröder
Date:
Subject: Re: (Never?) Kill Postmaster?
Next
From: Tom Lane
Date:
Subject: Re: Syntax error in a large COPY