Re: link tables - Mailing list pgsql-novice

From Jonatan Malaver
Subject Re: link tables
Date
Msg-id 58E13A9FA1D4994EB29384A8025A97B21BBFB2F2@mbx027-e1-nj-6.exch027.domain.local
Whole thread Raw
In response to Re: link tables  (David G Johnston <david.g.johnston@gmail.com>)
Responses Re: link tables
List pgsql-novice
| -----Original Message-----
| From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-
| owner@postgresql.org] On Behalf Of David G Johnston
| Sent: Friday, May 09, 2014 11:42 AM
| To: pgsql-novice@postgresql.org
| Subject: Re: [NOVICE] link tables
|
| Jonatan Malaver wrote
| >     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.
|
| Define what you specifically mean by "link".
|
| 9.2 does have "Foreign Data Wrapper" functionality so if you can locate an
| appropriate implementation for MS SQL you would be able to do whatever
| that "fdw" allows - which at minimum is perform select queries against
| foreign tables.
|
| David J.
|

I would like to JOIN two tables one is in Postgresql and the other one in MS SQL. Is that possible?
Thanks,
Jon


pgsql-novice by date:

Previous
From: Keith
Date:
Subject: Re: link tables
Next
From: Keith
Date:
Subject: Re: link tables