| -----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
That is possible with the foreign data wrappers yes, but I doubt the performance is going to be very good. I think you'd be better off getting the table replicated on a regular basis from MS SQL to Postgres. I'm not aware of an easy manner of doing this. Hopefully someone else on the list can help.