Re: link tables

| -----Original Message-----
| From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-
| owner(at)postgresql(dot)org] On Behalf Of Thomas Kellerer
| Sent: Monday, May 12, 2014 2:17 AM
| To: pgsql-novice(at)postgresql(dot)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(at)postgresql(dot)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