How to link from Postgresql to SQL Server via ODBC?

Question

I need to be able to query a SQL Server database from within Postgresql. The Postgres instance is running locally and the SQL server set up as an ODBC data source. How do I add this as a linked server? Is there a better approach?

Thanks

Craig Ringer · Accepted Answer · 2013-02-22 00:30:31Z

4

The two available options are:

DBI-Link; or
The ODBC-FDW (SQL/MED foreign data wrapper)

DBI-link is more mature, and will work on Windows. The ODBC FDW is likely to be better once it's properly finished, but at this point it isn't, and AFAIK it is not available on Windows.

See:

answered Feb 22, 2013 at 0:30

Craig Ringer

329k83 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user533832 Over a year ago

Do you know if the ODBC FDW is properly finished now Craig?

Craig Ringer Over a year ago

@JackDouglas Unless someone else has picked it up it is moribund. The last commit is 2 years ago. github.com/ZhengYang/odbc_fdw . The fork graph shows a few people working on it, including Andrew Dunstain (github.com/ZhengYang/odbc_fdw/network), but no sustained effort.

user533832 Over a year ago

Thanks, I've been using dbi-link for years and I think I will stick with it for now :)

Collectives™ on Stack Overflow

How to link from Postgresql to SQL Server via ODBC?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related