Re: Connect to SQL Server via ODBC from Postgresql

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