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