Klint Gore wrote: > Maybe these things from pgfoundary might help > > http://pgfoundry.org/projects/dbi-link/ > > http://pgfoundry.org/projects/odbclink/ > > http://pgfoundry.org/projects/dblink-tds/ Thank you for the links. I'm just getting into looking at them now. I had forgotten to say before that my instance of postgresql is running on windows. I can't seem to find any evidence of freetds running on windows, I guess there is not a great deal of need since MS's native client is there. So I'm thinking of re-writing the dblink-tds to use Mircosoft's native client rather than tds. The odbclink does not have any files yet, but looks like exactly what I'd need. David. -----Original Message----- From: Klint Gore [mailto:kgore4@xxxxxxxxxx] Sent: 27 June 2008 00:45 To: David Rowley Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] dblink to non postgresql dbms David Rowley wrote: > > Hello all, > > I'm looking for a solution to query a SQL Server 2000 instance from > PostgreSQL 8.3.3. > > I've been trawling the internet for some type of solution with out any > luck, I only found old references to someone talking about > implementation of create database link to postgresql > > Does anyone know of anything? > > I'm trying to avoid having to write a C table returning function. > > Any help would be much appreciated > Maybe these things from pgfoundary might help http://pgfoundry.org/projects/dbi-link/ http://pgfoundry.org/projects/odbclink/ http://pgfoundry.org/projects/dblink-tds/ -- Klint Gore Database Manager Sheep CRC A.G.B.U. University of New England Armidale NSW 2350 Ph: 02 6773 3789 Fax: 02 6773 3266 EMail: kgore4@xxxxxxxxxx
