Re: Connect postgres to SQLSERVER - Mailing list pgsql-general

From Atri Sharma
Subject Re: Connect postgres to SQLSERVER
Date
Msg-id CAOeZVifyz3JbLxw+Jm6HBSqTV+60uDE7nEx3ifxaAYNoTzo1ww@mail.gmail.com
Whole thread Raw
In response to Re: Connect postgres to SQLSERVER  (Igor Neyman <ineyman@perceptron.com>)
List pgsql-general
On Wed, Sep 18, 2013 at 12:11 AM, Igor Neyman <ineyman@perceptron.com> wrote:
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Agustin
Larreinegabe
> Sent: Tuesday, September 17, 2013 2:06 PM
> To: PostgreSQL mailing lists
> Subject: [GENERAL] Connect postgres to SQLSERVER
>
> HI,
>
> Is there a way to connect to a sqlserver like dblink?
> I just need to execute a Procedure in sqlserver when something happen
>
> --
> Gracias
> -----------------
> Agustín Larreinegabe
>
> -------------------------------------------------------------------------------------------------
>
> One option is to use "Linked Server" feature to connect from MS SQL Server to Postgres through ODBC driver.
>
> Regards,
> Igor Neyman
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


Or use a FDW, like JDBC_FDW.


pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: Re: Connect postgres to SQLSERVER
Next
From: Vick Khera
Date:
Subject: Re: ZFS snapshots - to use pg_start_backup() and pg_stop_backup() or no?