Re: [SQL] How to write sql to access another odbc source.

2011-10-25 Thread Craig Ringer
On 19/10/11 22:08, Rich wrote: > I have a mumps database with an ODBC connection so I can write queries > from other databases. How can I write a sql in Postgresql to access > this table to use in my Postgresql reports? Use dbi-link to make an ODBC connection to the other database. Either copy th

[SQL] How to write sql to access another odbc source.

2011-10-25 Thread Rich
I have a mumps database with an ODBC connection so I can write queries from other databases. How can I write a sql in Postgresql to access this table to use in my Postgresql reports?