| From: | Jonatan Malaver <jon(dot)malaver(at)shrewsburyma(dot)gov> |
|---|---|
| To: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: link tables |
| Date: | 2014-05-09 17:16:40 |
| Message-ID: | 58E13A9FA1D4994EB29384A8025A97B21BBFB2F2@mbx027-e1-nj-6.exch027.domain.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
| -----Original Message-----
| From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-
| owner(at)postgresql(dot)org] On Behalf Of David G Johnston
| Sent: Friday, May 09, 2014 11:42 AM
| To: pgsql-novice(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith | 2014-05-09 18:40:43 | Re: link tables |
| Previous Message | Keith | 2014-05-09 15:42:49 | Re: link tables |