Re: link tables

| -----Original Message-----
| From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-
| owner@postgresql.org] On Behalf Of Thomas Kellerer
| Sent: Monday, May 12, 2014 2:17 AM
| To: pgsql-novice@postgresql.org
| Subject: Re: [NOVICE] link tables
| 
| Keith, 09.05.2014 20:40:
| >> 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.
| 
| If the table isn't too big, a materialized view based on a foreign table could do
| the trick.
| 
| 
| 
| 
| --
| Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make
| changes to your subscription:
| http://www.postgresql.org/mailpref/pgsql-novice


I'm currently checking out this alternative https://github.com/GeoffMontee/tds_fdw
Jon