Patch attached

postgres sql command COPY now works with null dates in csv files.
--- mdbtools-0.5.99.0.6pre1.0.20051109.orig/src/util/mdb-export.c 2006-01-30 17:21:51.000000000 +0100
+++ mdbtools-0.5.99.0.6pre1.0.20051109/src/util/mdb-export.c 2010-01-14 12:44:55.000000000 +0100
@@ -205,8 +205,8 @@
            if (j>0) {
                fprintf(stdout,delimiter);
            }
-           if (insert_statements && !bound_lens[j]) {
-               print_col("NULL",0,col->col_type, quote_char, escape_char);
+           if (!bound_lens[j]) {
+               print_col(insert_statements?"NULL":"", 0, col->col_type, quote_char, escape_char);
            } else {
                print_col(bound_values[j], quote_text, col->col_type, quote_char, escape_char);
            }

Reply via email to