Re: PostgreSQL and import/export to dbf and mdb

Поиск
Список
Период
Сортировка
От Sean Davis
Тема Re: PostgreSQL and import/export to dbf and mdb
Дата
Msg-id 200703120640.01528.sdavis2@mail.nih.gov
обсуждение исходный текст
Ответ на Re: PostgreSQL and import/export to dbf and mdb  (" Jaromír Kamler" <kamler@centrum.cz>)
Список 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 по дате отправления:

Предыдущее
От: " Jaromír Kamler"
Дата:
Сообщение: Re: PostgreSQL and import/export to dbf and mdb
Следующее
От: Brian Hurt
Дата:
Сообщение: plpgsql: inserting a record into a (matching) table