Home > mailing lists

Re: link tables - Mailing list pgsql-novice

From	Keith
Subject	Re: link tables
Date	May 9, 2014 15:43:36
Msg-id	CAHw75vvH=B9quJdCguthKqVdf5vi1bXiWq3rv=TXo1NpdTQUVw@mail.gmail.com Whole thread Raw
In response to	link tables (Jonatan Malaver <jon.malaver@shrewsburyma.gov>)
List	pgsql-novice

On Fri, May 9, 2014 at 11:28 AM, Jonatan Malaver <jon.malaver@shrewsburyma.gov> wrote:

Hello,

Is there a way to link a table from MS SQL to postgresql table? I’m uysing CentOS 6.5 x64 with postgresql 9.2.

Thanks,

Jon

Look into Foreign Data Wrappers. Not aware of one dedicated specifically to MS SQL yet

http://wiki.postgresql.org/wiki/Foreign_data_wrappers

ODBC one says it doesn't work with 9.2 yet. The JDBC one may work if you have that driver available.

From: David G Johnston
Date: 09 May 2014, 15:42:03
Subject: Re: link tables

From: Jonatan Malaver
Date: 09 May 2014, 17:17:36
Subject: Re: link tables