Search Postgresql Archives

Connect to SQL Server via ODBC from Postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux