Re: Connect to SQL Server via ODBC from Postgresql - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Connect to SQL Server via ODBC from Postgresql
Date
Msg-id 47864962.10508@commandprompt.com
Whole thread Raw
In response to Re: Connect to SQL Server via ODBC from Postgresql  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
Merlin Moncure wrote:
> On Jan 4, 2008 11:51 AM, Afewtips.com <afewtips@gmail.com> wrote:
>>> I do read mentions about dblink connections, but how to install it
>>> looks unclear and complicated.
>>>
>
> small clarification here.  dblink is for connecting two postgresql
> databases together.  It is, IMO, neither unclear nor complicated :-).
> dbilink, (note the 'I'), which aiui uses perl dbi in a dblink style
> interface...never used it personally.
>
> for moving data in and out of sql server and postgresql, you have a
> number of options, odbc, dbi, php, etc etc.  in the end, you have to
> query a, process the result and send the answer to b.

There is a PostgreSQL project explicitly for this type of thing...

dbi-link: http://pgfoundry.org/projects/dbi-link/

Sincerely,

Joshua D. Drake



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.2.4 serious slowdown
Next
From: "Scott Marlowe"
Date:
Subject: Re: 8.2.4 serious slowdown