RE: [GENERAL] Importing to Postgres from Filemaker Pro

ODBC may be a solution.

I dont know if Filemaker supports ODBC, but if it does you can open the
database in Filemaker and connect to postgres via ODBC and move the data to
postgres that way.

Gregory S. Youngblood
ext 2164
 
 

-----Original Message-----
From: Adam Haberlach [mailto:haberlaa(at)ricochet(dot)net]
Sent: Sunday, January 31, 1999 2:50 PM
To: pgsql-general(at)postgreSQL(dot)org
Subject: [GENERAL] Importing to Postgres from Filemaker Pro

Has anyone out there done any work getting data from
a FileMaker database into postgres? I have about 16000 fairly
large records that I need to move from a crufty MacOS machine
to a Linux box. I also have Filemaker for NT handy, as well
as Lasso. At least four of the fields in the database can
contain commas, tabs, and many other simple delimiters.
Right now it looks like I may have to export from
Filemaker into a giant HTML table, and then parse that into
a bunch of INSERT commands with a special program.

In short: anyone have any simple tools to import
complex .csv, .tab or other common flat files into postgres?