Connect to SQL Server via ODBC from Postgresql

From: "Afewtips(dot)com" <afewtips(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Connect to SQL Server via ODBC from Postgresql
Date: 2008-01-04 15:08:49
Message-ID: 85641af1-bd5d-41cf-b6b1-ec40efddf33a@e23g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I am new to this product and don't quite know what can and cannot be
done.

I need to submit queries to a SQL Server database and create a table
in Postgresql with the results from SQL Server.

Normally I would do this with an ODBC driver into SQL Server, but I
don't see any references to doing that with Postgresql, only connect
to the Postgresql table from another database with ODBC.

I do read mentions about dblink connections, but how to install it
looks unclear and complicated.

(I didn't install the PostgreSQL source and it seems that it is needed
to install dblink. Does dblink have a standard application install?)

I am running 8.2 - any help would be very appreciated!

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Glaesemann 2008-01-04 15:13:16 Re: How to handle 'not a number' in postgresql
Previous Message Ivan Sergio Borgonovo 2008-01-04 15:02:54 Re: Best free open source ER diagram generator?