Re: PostgreSQL and import/export to dbf and mdb - Mailing list pgsql-novice

From Sean Davis
Subject Re: PostgreSQL and import/export to dbf and mdb
Date
Msg-id 200703120640.01528.sdavis2@mail.nih.gov
Whole thread Raw
In response to Re: PostgreSQL and import/export to dbf and mdb  (" Jaromír Kamler" <kamler@centrum.cz>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: " Jaromír Kamler"
Date:
Subject: Re: PostgreSQL and import/export to dbf and mdb
Next
From: Brian Hurt
Date:
Subject: plpgsql: inserting a record into a (matching) table