| From: | Keith <keith(at)keithf4(dot)com> |
|---|---|
| To: | Jonatan Malaver <jon(dot)malaver(at)shrewsburyma(dot)gov> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: link tables |
| Date: | 2014-05-09 15:42:49 |
| Message-ID: | CAHw75vvH=B9quJdCguthKqVdf5vi1bXiWq3rv=TXo1NpdTQUVw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Fri, May 9, 2014 at 11:28 AM, Jonatan Malaver <
jon(dot)malaver(at)shrewsburyma(dot)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 | Date | Subject | |
|---|---|---|---|
| Next Message | Jonatan Malaver | 2014-05-09 17:16:40 | Re: link tables |
| Previous Message | David G Johnston | 2014-05-09 15:41:58 | Re: link tables |