Thread: PostgreSQL and import/export to dbf and mdb
Hallo, I need some utility for importing database from dbf and mdb to PostgreSQL and export it back from PgSQL to mdb and dbf. Iwas trying find out something useable, but I can not find nothing. Thanks Jaromir Kamler
From MBD to Postgres --> Export the table as a flat-file TSV and import it using the COPY command.
From Postgres to MDB --> Setup Postgres as an ODBC data source?
~p
On Fri, 2007-03-09 at 10:49 +0100, Jaromír Kamler wrote:
From Postgres to MDB --> Setup Postgres as an ODBC data source?
~p
On Fri, 2007-03-09 at 10:49 +0100, Jaromír Kamler wrote:
Hallo, I need some utility for importing database from dbf and mdb to PostgreSQL and export it back from PgSQL to mdb and dbf. I was trying find out something useable, but I can not find nothing. Thanks Jaromir Kamler ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
| Phillip Smith IT Coordinator Weatherbeeta P/L 8 Moncrief Rd Nunawading, Vic, 3131 AUSTRALIA P. +613 9845 0600 F. +613 9845 0655 E. phillip.smith@weatherbeeta.com.au |
Attachment
Hallo, thans for your reply. There is no ODBC. I need import some tables to PgSQL, create some new tables and that new tables export back to *.dbf and*.mdb. I use it in specific program, which can work only with database files (dbf, mdb, ...). ______________________________________________________________ > Od: phillip.smith@weatherbeeta.com.au > Komu: JaromĂr Kamler <kamler@centrum.cz> > CC: pgsql-novice@postgresql.org > Datum: 09.03.2007 11:17 > Předmět: Re: [NOVICE] PostgreSQL and import/export to dbf and mdb > From MBD to Postgres --> Export the table as a flat-file TSV and import >it using the COPY command. From Postgres to MDB --> Setup Postgres as an ODBC data source? > >~p > >On Fri, 2007-03-09 at 10:49 +0100, Jaromír Kamler wrote: > >> Hallo, >> I need some utility for importing database from dbf and mdb to PostgreSQL and export it back from PgSQL to mdb and dbf. I was trying find out something useable, but I can not find nothing. >> >> Thanks >> Jaromir Kamler >> >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 5: don't forget to increase your free space map settings >> > >Phillip Smith >IT Coordinator >Weatherbeeta P/L >8 Moncrief Rd >Nunawading, Vic, 3131 >AUSTRALIA > >P. +613 9845 0600 >F. +613 9845 0655 >E. phillip.smith@weatherbeeta.com.au > > Ing. Jaromír Kamler Pozemkový úřad Jeseník
On Monday 12 March 2007 06:18, Jaromír Kamler wrote: > Hallo, thans for your reply. > > There is no ODBC. I need import some tables to PgSQL, create some new > tables and that new tables export back to *.dbf and *.mdb. I use it in > specific program, which can work only with database files (dbf, mdb, ...). You might look into using something like this: http://search.cpan.org/~janpaz/DBD-XBase-0.241/lib/XBase.pm for working with the files. You could load the files using perl, dump from perl into postgres, do your manipulations, retrieve back into perl from postgres, and then write the new files. If the manipulations are not too complex, they might be better done in perl only. Sean