pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC and BLOBs
2+ messages / 2 participants
[nested] [flat]
* ODBC and BLOBs
@ 2000-01-30 14:49 Frank Joerdens <frank@joerdens.de>
0 siblings, 1 reply; 2+ messages in thread
From: Frank Joerdens @ 2000-01-30 14:49 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] ODBC and BLOBs
@ 2000-01-30 22:00 Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>
parent: Frank Joerdens <frank@joerdens.de>
0 siblings, 0 replies; 2+ messages in thread
From: Ross J. Reedstrom @ 2000-01-30 22:00 UTC (permalink / raw)
To: Frank Joerdens <frank@joerdens.de>; +Cc: pgsql-interfaces
On Sun, Jan 30, 2000 at 03:49:55PM +0100, Frank Joerdens wrote:
>
> I cannot just try this because I don't have the Win32 version of FileMaker
> (which is not exactly cheap).
Last time I looked, (about a year ago...) there was a free trial download
of Win32 FileMakePro. The only limitation built in to it was it would only
view 50 records at a time. You could try with that.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-01-30 22:00 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-01-30 14:49 ODBC and BLOBs Frank Joerdens <frank@joerdens.de>
2000-01-30 22:00 ` Ross J. Reedstrom <reedstrm@wallace.ece.rice.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox