Re: FileMakerPro to postgreSQL - Mailing list pgsql-general

From Tom Lane
Subject Re: FileMakerPro to postgreSQL
Date
Msg-id 11959.1158546514@sss.pgh.pa.us
Whole thread Raw
In response to FileMakerPro to postgreSQL  (brew@theMode.com)
Responses Re: FileMakerPro to postgreSQL  (Shane Ambler <pgsql@007Marketing.com>)
Re: FileMakerPro to postgreSQL  (brew@theMode.com)
List pgsql-general
brew@theMode.com writes:
> ... My biggest concern is the existing FileMakerPro clients.  How much work
> would it be to connect the existing FMP clients to the postgreSQL database
> using ODBC?  Is this a viable temporary step or could it be permanent?

If they can speak ODBC, then in theory you can easily connect them to PG
that way.  There's a fair-size gap between theory and practice, however
--- for example, the clients might be depending on some nonstandard SQL
syntax.   The only way to really check this out is to test the clients
against PG and see what comes up.  See the pgsql-odbc list archives for
some examples of gotchas.

            regards, tom lane

pgsql-general by date:

Previous
From: brew@theMode.com
Date:
Subject: FileMakerPro to postgreSQL
Next
From: "Jim C. Nasby"
Date:
Subject: Re: [HACKERS] One of our own begins a new life