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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match