Edward,
> To help with my work, I've created a basic plugin that allows Postgres
> to retreive data from tables on other databases via ODBC. So far I've
> only tested it against MS SQL Server 2000. It's rather crude at the
> moment, as the only operation supported is a SELECT * query, and it
> currently requires the username/password to be hard coded into the
> source code.
http://pgfoundry.org/projects/dbi-link/
http://pgfoundry.org/projects/dblink-tds/
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco