Re: Exporting data for import into Postgres
Jeff Smith <[email protected]>
| Newsgroups | gmane.comp.db.mdb-tools.devel |
|---|---|
| Message-ID | <[email protected]> |
Paul, If you are using mdbtools out of CVS from Sep '05 or later, there are already sufficient options to accomplish what you want (except perhaps the \ escaping problem). Note that the '-q <char>' option is currently misdocumented as '-Q <char>'. I intend to fix this once sourceforge's CVS starts working again. mdb-export -I -S -q"'" -R";\n" sample.mdb Table1 -- Jeff Smith --- Paul Schulz <[email protected]> wrote: > Greetings, > > Please find attached a patch which provides a '-p' option to > mdb-export, which when used with the -I and -S, allows data to be > directly imported 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 patch add this. > > There is another issue with '\'s in the data still being passed > directly without being escaped. This is a problem where I have > 'windows' pathnames stored, and a training '\' will inadvertently > escape the single quote delimiter. > > Cheers, > Paul Schulz __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642