> How can I "binds" PostgreSQL to consider '' as null ? You can modify src/backend/utils/{datetime,date,timestamp}.c to accept an empty string as a null value. But imho it is better to fix this in your input file, perhaps using sed: sed "s/''/NULL/g" < informix.dump > pg.dump - Thomas ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
- [BUGS] Error in the date field (with NULL value...).Thank... Maurizio Ortolan
- Thomas Lockhart