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?
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@ricochet.net]
Sent: Sunday, January 31, 1999 2:50 PM
To: pgsql-general@postgreSQL.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?
Import Notes
Resolved by subject fallback
Look at the COPY utility in the pgsql/bin dir and the COPY sql command
under psql...
-DEJ
Show quoted text
-----Original Message-----
From: Greg Youngblood [mailto:YoungblG@houstoncellular.com]
Sent: Monday, February 01, 1999 2:05 PM
To: 'Adam Haberlach'; pgsql-general@postgreSQL.org
Subject: RE: [GENERAL] Importing to Postgres from Filemaker ProODBC 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@ricochet.net]
Sent: Sunday, January 31, 1999 2:50 PM
To: pgsql-general@postgreSQL.org
Subject: [GENERAL] Importing to Postgres from Filemaker ProHas 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?
Import Notes
Resolved by subject fallback