Re: link tables

On Fri, May 9, 2014 at 1:16 PM, Jonatan Malaver <
jon(dot)malaver(at)shrewsburyma(dot)gov> wrote:

>
> | -----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
>
>
> --
> 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
>

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.