| From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Cc: | " Jaromír Kamler" <kamler(at)centrum(dot)cz>, phillip(dot)smith(at)weatherbeeta(dot)com(dot)au |
| Subject: | Re: PostgreSQL and import/export to dbf and mdb |
| Date: | 2007-03-12 10:40:01 |
| Message-ID: | 200703120640.01528.sdavis2@mail.nih.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brian Hurt | 2007-03-13 18:41:49 | plpgsql: inserting a record into a (matching) table |
| Previous Message | Jaromír Kamler | 2007-03-12 10:18:39 | Re: PostgreSQL and import/export to dbf and mdb |