I'm trying to bulk load CVS data into my postgres database. All my data files contain a field header & most are quote enclosed. Is there an alternative for handling the optionally enclosed feature that does not exist for the COPY FROM?

Is there any word on when COPY will be modified to support both COPY FROM and IGNORE REPLACE?


Matt Sample
Ultrasound L9 DFR/Warranty Champion
GE Healthcare Technologies

T 414.647.6540
F 414.647.4090
C 262.442.0028
D 8*767.6540
E matthew.sample (AT) med (DOT) ge.com
www.gehealthcare.com



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match