On 9/17/07, soni de <soni.de@xxxxxxxxx> wrote: > We have upgraded postgres from 7.2.4 to 8.2.0. > We have program which executes COPY command and our new database is changed > having some extra columns in some tables. > Because of this, COPY commands are failing. > So, we wanted the option to COPY the data without specifying column names. Can't you just edit the import to have the newer 8.2.x syntax of COPY table (field1, field2, field3, field4) FROM stdin; ??? And please tell me you aren't running 8.2.0, but 8.2.4 or now that it just came out, 8.2.5. Those minor point releases contain a lot of bug fixes, and you're just asking for trouble by running a .0 release. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
