| -----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