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