Postgresql ODBC features

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
Posts: 1
Joined: Fri 05 Feb 2016 09:49

Postgresql ODBC features

Post by chocholousp » Fri 05 Feb 2016 09:57


could you please name some features which will make me use devart ODBC drivers instead of free postgresql ODBC. I am specially interested in network connection stability (e.g. reconnect capability or compression) and performance. Do you have any benchmarks?

Thanks, Pavel

Devart Team
Posts: 1001
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Postgresql ODBC features

Post by azyk » Thu 11 Feb 2016 08:15

For the time being, we have implemented and now testing the following functionality of ODBC driver for PostgreSQL, that is absent in standard ODBC drivers:
- support for Linux and MacOS (FreeBSD coming soon)
- secure connection to PostgreSQL using SSH tunnel and SSL protocols.

In addition, users of our products, ODBC driver for PostgreSQL in particular, get advantages of user support:
- frequent releases( ... story.html );
- product purchase provides annual subscription for free updates.

Currently, the Devart driver shows similar or higher performance in comparison to the standard ODBC drivers.

Posts: 1
Joined: Fri 04 Mar 2016 17:58

Re: Postgresql ODBC features

Post by nreyest » Fri 04 Mar 2016 18:01

I can't use materialized views with the free odbc driver; is there support on your product for postgresql materialized views? or in the excel add-in? or any of your products?


Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Postgresql ODBC features

Post by AlexP » Mon 07 Mar 2016 11:20

In ODBC driver you can get data from such views using a query. In the current version, such views won't be displayed in the object tree. We will add this feature in the next version.

Post Reply