hi, it would be useful if its possible to be able to give column list with COPY sql command. (like mysql's LOAD DATA command) and INTEGER PRIMARY KEY fields doesn't get it's value automatically.
CREATE TABLE test (id INTEGER PRIMARY KEY,a CHAR(10)); file xxx: \N value1 \N value2 ... COPY test FROM 'xxx' --> SQL error: datatype mismatch ofcourse i can remove id field from db and i can use ROWID when i need it, but its realy neccessary? thank you and sorry for bad english. semseddin moldibi - bircom telecommunications
