[GENERAL] Connect to SQL Server via ODBC from Postgresql

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

---------------------------(end of broadcast)---------------------------