Posted on 2009-10-26 New version of OLEDB provider for PostgreSQL database includes following features and enhancements: • Ability to work with multiple databases via single Linked Server connection. • Support for SSL and SSPI. • Support for arrays. • Enhanced expression types evaluator. • Support for nested transactions. • Support for distributed transactions (DTC enlistment).
Note: Before you can connect to a PostgreSQL database in Power Query, you need the Ngpsql data provider for PostgreSQL installed on your computer. Select the driver that matches your Office version (32-bit or 64-bit). Oct 30, 2008 - PostgreSQL Native Provider (PGNP) is an OLEDB Provider for PostgreSQL database. The provider is a thin layer between Microsoft ADO and. Zenkov & Software Engineering: PostgreSQL Native Provider (PGNP) is an OLEDB Provider for PostgreSQL database. The provider is a thin layer between Microsoft ADO and PostgreSQL API exposed via libpq library. It implements most of the OLEDB interfaces and uses libpq to access a PostgreSQL database.