Re: 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. I was 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:

> 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(dot)smith(at)weatherbeeta(dot)com(dot)au

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(dot)smith(at)weatherbeeta(dot)com(dot)au
> Komu: JaromĂ­r Kamler <kamler(at)centrum(dot)cz>
> CC: pgsql-novice(at)postgresql(dot)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(dot)smith(at)weatherbeeta(dot)com(dot)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