Received: from flateric.x9media.com ([62.104.116.67])
	by hub.org (8.9.3/8.9.3) with ESMTP id JAA96923
	for <pgsql-interfaces@postgreSQL.org>;
	Sun, 30 Jan 2000 09:49:03 -0500 (EST)
	(envelope-from frank@joerdens.de)
Received: (from frank@localhost)
	by flateric.x9media.com (8.8.7/8.8.7) id PAA17918
	for pgsql-interfaces@postgreSQL.org; Sun, 30 Jan 2000 15:49:55 +0100
Date: Sun, 30 Jan 2000 15:49:55 +0100
From: Frank Joerdens <frank@joerdens.de>
To: pgsql-interfaces@postgreSQL.org
Subject: ODBC and BLOBs
Message-ID: <20000130154955.A17897@flateric.x9media.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.1i

I am looking for a way to import data from a Macintosh FileMaker Pro database
into PostgreSQL. If I just use the text mode export feature in FileMaker, I'll
lose all the multimedia data, i.e. images and Quicktime clips.

My thinking was that I might use the Win32 version of FileMaker and the Insight
Windows ODBC driver to get the BLOBs into PostgreSQL. This sounds a wee bit like
a long shot, since I don't know whether

a) FileMaker can export large objects even if both the ODBC driver and the DBMS
properly support it

b) the Insight driver will handle it (the FAQ on the Insight page mentions 
some support for large objects but also says that the support within
PostgreSQL is lacking in functionality)

c) this will be very useful, given the caveat on the Insight page as to the 
functionality of BLOBs in PostgreSQL

I cannot just try this because I don't have the Win32 version of FileMaker
(which is not exactly cheap).

I am wondering whether anyone has an opinion on and/or experience with this 
problem or a similar issue, or any ideas as to how to go about solving this
problem in a completely different way.

Any suggestions are welcome.

- Frank