Re: Connect postgres to SQLSERVER

From: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
To: Igor Neyman <ineyman(at)perceptron(dot)com>
Cc: Agustin Larreinegabe <alarreine(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Connect postgres to SQLSERVER
Date: 2013-09-17 18:49:50
Message-ID: CAOeZVifyz3JbLxw+Jm6HBSqTV+60uDE7nEx3ifxaAYNoTzo1ww@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 18, 2013 at 12:11 AM, Igor Neyman <ineyman(at)perceptron(dot)com> wrote:
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

Or use a FDW, like JDBC_FDW.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2013-09-17 19:33:38 Re: ZFS snapshots - to use pg_start_backup() and pg_stop_backup() or no?
Previous Message Igor Neyman 2013-09-17 18:41:15 Re: Connect postgres to SQLSERVER