Re: 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.