Re: Connect to SQL Server via ODBC from Postgresql

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
Cc: Sim Zacks <sim(at)compulab(dot)co(dot)il>, pgsql-general(at)postgresql(dot)org
Subject: Re: Connect to SQL Server via ODBC from Postgresql
Date: 2008-01-09 07:16:53
Message-ID: 478474E5.9060604@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ow Mun Heng wrote:
> On Wed, 2008-01-09 at 08:41 +0200, Sim Zacks wrote:
>> Another way of doing this, without dblink, is using an unsecured language
>> (plpython, for example) is to connect to the sql server using odbc and then
>> putting the data into your postgresql.
>
> I use perl DBI to connect to both PG and MSSQL.
>

Perl or Python both would service this just fine or PHP (egads).

Sincerely,

Joshua D. Drake

>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ow Mun Heng 2008-01-09 07:16:59 Re: Connect to SQL Server via ODBC from Postgresql
Previous Message Ow Mun Heng 2008-01-09 07:14:48 Re: Experiences with extensibility