Getting SQL error with CSV NUMERIC NULL

Hi,

I’m trying to convert a MySQL table to PostgreSQL, but when I create the CSV file with CSVWriter, a NUMERIC field who have NULL values was receiving “” (quote quote) instead “NULL”, then the SQL generated is invalid as it:


                  INSERT INTO table (field1, field2, field3) VALUES (1, , ‘John’);
Anyone knows what’s going on?

Regards,

Thiago



Are you using liquibase 2.0.3?

Nathan

Yes Nathan.

Actually i couldnt wait for an answer then I’ve created my own csv writer (not that hard). I’m developing a backup tool for MySQL, PostgreSQL and SQLServer and tanks to liquibase, I’ve progressed a lot.

Anyway, dunno why the error.

Thiago