mdb-export - SQL not correct for import into postgres.
Bug #42867 reported by
PaulSchulz
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mdbtools (Ubuntu) |
Fix Released
|
Low
|
Jean-Michel Vourgère |
Bug Description
Attempting to import a MSAccess database into PostgreSQL.
Using 'mdb-export' with the -I and -S options produces INSERT statements that almost work except for:
- " (double quotes) are used to delimiter data, instead of single quotes.
- The is no semicolon (';') at the end of each line.
The attached patch allows a '-p' option to be used (with -I and -S and) which willfix these issues.
Changed in mdbtools: | |
importance: | Medium → Low |
status: | New → Triaged |
Changed in mdbtools (Ubuntu): | |
assignee: | nobody → Jean-Michel Vourgere (jmv-deb) |
status: | Triaged → In Progress |
Changed in mdbtools (Ubuntu): | |
status: | In Progress → Fix Committed |
Changed in mdbtools (Ubuntu): | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
(How do I attach a patch file?)