[mdb-dev] mdb-export and PostgreSQL

[Markus N. <ne...@it...>]

Hi,

I am currently trying to get MDB data into a PostgreSQL database.
Running

mdb-export -S -I StazioniAutomatiche.mdb Misure
...
INSERT INTO Misure (Id_Misura, Descrizione_Misura, UM) VALUES (236,"Tensione minima giornaliera batteria","V")
...

To make PostgreSQL happy, a semicolon is needed at the end of each
line (also reported:
 http://sourceforge.net/mailarchive/forum.php?thread_id=7234522&forum_id=5183
). I have patched src/util/mdb-export.c accordingly (line 185), but I feel
that this should go somehow into CVS.

A second problem is that all " (double) quotes need to be ' (single) quotes,
otherwise PostgreSQL won't insert. Not sure where to fix this one in 
the C code.

I have a shell workaround using tr and sed, but would prefer a fix in
the source code (to avoid future traps).

Thanks

 Markus