ODBC Driver for PostgreSQL

More ODBC Drivers

Devart ODBC Driver for PostgreSQL provides a high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases from Windows, macOS, Linux, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes interaction of your database applications with PostgreSQL fast, easy and extremely handy.

How Does Devart ODBC Driver Stack Up Against Database Vendor Driver?

Features
Devart ODBC Driver
Database Vendor Driver
ODBC 3.52 compliant driver
Yes
Yes
Direct connection to data source without client software
Yes
No
Full compliance with ODBC API and data types
Yes
No
SSL-protected communication
Yes
Yes
SSH-protected communication
Yes
No
HTTPS Proxy communication
Yes
No
Compatibility with the latest server versions
Yes
Yes
Verified compatibility with multiple BI and ETL tools
Yes
No
Fast parallel bulk data loading
Yes
Yes
Auto-install in a few clicks
Yes
No
Support for 32-bit and 64-bit applications
Yes
Yes
Available for Windows, Linux and macOS
Yes
Yes
Unicode support: different languages and data types
Yes
Yes
Nightly builds with the most recent changes and hotfixes
Yes
No
Dedicated support team of software engineers
Yes
No
Forum community of people who use ODBC drivers
Yes
No
ODBC 2.x behavior emulation
Yes
No
Support for popular programming languages
Yes
Yes

Direct Connection

Database applications based on our solution get an opportunity to establish a connection to PostgreSQL directly. Direct Connection gives your applications an unrivalled advantage — connection to PostgreSQL databases directly via TCP/IP avoiding PostgreSQL Client. That improves performance of your applications, their quality, reliability and especially the deployment process, since there is no need to supply additional client software together with your application.

Native Connectivity to PostgreSQL

What are some reasons to choose Devart ODBC Driver for PostgreSQL?

Integration

The driver is compatible with 3rd-party tools for data analysis, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, etc.

For the complete list of compatible tools and environments visit the Compatibility page.

Platforms Variety

ODBC Driver for PostgreSQL can be used with 32-bit and 64-bit applications on both x32 and x64 platforms, so there is no need to additionally configure the driver, applications or environment.

Fully Unicode Driver

With our fully Unicode driver, you can retrieve and work with any data from multi-lingual PostgreSQL databases correctly, not depending on whether its charset is Latin, Cyrillic, Hebrew, Chinese, etc., in any environment localization.

Features Overview

SSL Encryption

SSL Encryption

Work with PostgreSQL securely using SSL connection options provided in our driver along with the support for SSL protocol.

SSH Secure Connection

SSH Secure Connection

You can also connect to PostgreSQL securely via SSH tunnel. SSH protocol is one of the most reliable protocols for data encryption.

Advanced Data Conversion

Advanced Data Conversion

We have implemented advanced Data Conversion mechanisms that provide bi-directional mapping between any PostgreSQL and ODBC data types.

ODBC Conformance

The driver provides full support for common ODBC interface:

  • ODBC API Functions support
  • ODBC Data Types support

In addition, we provide support for Advanced Connection String parameters, thus allowing any desktop and web applications to connect to PostgreSQL from various environments and platforms that support ODBC.

Bulk Updates

Bulk Updates

Moreover, with our driver you can perform bulk updates to PostgreSQL database by combining SQL statements into batches, thus simplifying and speeding up large data modification to PostgreSQL.

PostgreSQL Compatibility

PostgreSQL Compatibility

Our driver is compatible with major and the latest PostgreSQL server versions up to 11. We also provide compatibility with Microsoft Azure Database for PostgreSQL, Amazon Aurora and Google Cloud for PostgreSQL.

High Performance

High Performance

Every operation with PostgreSQL becomes significantly faster using such capabilities of our driver as local data caching, connection pooling, and much more.

PostgreSQL Support

Support

Visit our Support page to get instant support from experienced professionals, fast and detailed responses, user engagement and interaction, frequent builds with bug fixes, and much more.