ODBC Driver for PostgreSQL Revision History

5.1.0 16-Apr-26

Added support for protocol 3.2
Added support for virtual generated columns
Added support for OAUTHBEARER authentication
Added the EnablePgTimeStamp connection option
Added the CurrentTimeZone connection option
Added the ExactTimeZone connection option
Added the ability to use SSL and SSH protocols simultaneously
Improved compatibility with Attunity Qlik Replicate
Improved compatibility with the PDO_ODBC PHP extension
Improved compatibility with Node.js
Fixed an issue with parsing a connection string when its value contained a sequence of SQL comment characters

5.0.0 10-Nov-25

Added a graphical interface for configuring the driver on macOS and Linux
Added support for PostgreSQL 18
Added support for Bearer Token authentication when using an HTTP tunnel
Improved the performance of opening connections
Improved compatibility with Node.js
Improved compatibility with Tableau
Improved compatibility with Vectorworks
Fixed a bug that occurred when working with partitioned tables
Fixed a bug that occurred when using metadata without a specified database name
Fixed an issue that caused incorrect connection string parsing on macOS
Fixed an issue with retrieving the list of stored procedures for the current schema

4.7.0 14-Apr-25

Added support for password-protected private keys for the SSL protocol
Improved compatibility with Microsoft Query
Fixed the "Invalid index definition" issue for Linked Server
Fixed an issue with editing File DSN

4.6.0 12-Nov-24

Added support for PostgreSQL 17
Added support for the pgvector extension
Added Read Only mode for connection
Fixed bug with a user using tables named pg_class
Fixed bug with re-activation ODBC driver via another Windows user

4.5.1 28-Mar-24

Fixed the issue when establishing a connection with a connection string that contains unsupported parameters

4.5.0 14-Mar-24

Added support for PostgreSQL 16
Now passwords are stored in an encrypted form in the DSN record
Improved compatibility with FileMaker Server for Linux and macOS
Fixed connection timeout setting before opening connection
Fixed bug with handling the numeric data type

4.4.2 03-Oct-23

Fixed bug with driver license validation for Linked Server in MSSMS

4.4.1 17-Aug-23

Improved compatibility with 4D in macOS
Fixed bug with getting data in DBeaver
Fixed Windows XP installation bug

4.4.0 15-May-23

Added support for PostGIS
Added support for SQL_ATTR_MAX_ROWS attribute
Improved compatibility with Visual Basic in Visual Studio
Fixed bug with using Min Fetch Rows

4.3.0 17-Nov-22

Added support for PostgreSQL 15
Added support for macOS 13 Ventura
Added support for the SCRAM-SHA-256-PLUS authentication mechanism
Improved compatibility with Tableau Prep Builder
Improved compatibility with Crystal Reports
Improved the SSH connection establishment
Fixed bug with TIMESTAMPTZ fields
Fixed bug when a connection string parameter value contains a single quote
Fixed an issue with adding DSN in PowerShell
Fixed an issue with rows deleting

4.2.1 05-Jan-22

Added support for Windows 11
Added support for PostgreSQL 14
Added support for OUT parameters in stored procedures in PostgreSQL 14
Improved compatibility with PostgreSQL 8.1 and 8.2
Improved compatibility with FICO Mosel
Improved compatibility with FileMaker
Improved compatibility with JMP on macOS
Improved support for an ODBC installer on Windows 2000
Fixed an issue with updating date and time fields in MS Access
Fixed a double function call
Fixed UUID with braces

4.1.1 08-Jul-21

MSI installer for deploying through GPO is added
Bug with executing the "call" macro with a stored procedure in PostgreSQL 11 and later is fixed

4.0.1 25-May-21

Apple Silicon M1 is supported
Compatibility with macOS Big Sur is improved
Bug with modifying data using the Linked Server is fixed

3.4.1 07-Dec-20

PostgreSQL 13 is supported
Compatibility with Clarion Enterprise is improved
Bug with accessing tables whose names contain spaces is fixed
Bug with reading milliseconds from TIMESTAMP columns is fixed
Bug with setting the SERIALIZABLE transaction isolation level is fixed

3.3.4 08-Apr-20

Materialized views are supported
Compatibility with Power Pivot is improved
Compatibility with Visual Basic is improved
Compatibility with RStudio is improved
Bug with modifying data using SQLSetPos is fixed
Bug with fetching by Bookmark is fixed

3.2.3 28-Nov-19

PostgreSQL 12 is supported

3.1.2 04-Oct-19

Amazon RDS for PostgreSQL is supported
Work with password-protected private key for SSH protocol is supported
Now ODBC driver activation does not require administrator privileges
Improved compatibility with sandboxed applications for macOS
Support for connection pooling is improved

3.0.1 08-Jan-19

PostgreSQL 11 is supported
Now ODBC driver for macOS is distributed as a PKG package
Now ODBC driver for Linux is distributed as DEB and RPM packages
Possibility to force the ODBC 2.x behavior is added

2.4.9 16-Jul-18

Possibility to show used connection string in the connection dialog is added
Bug with function execution using SQLExecDirect is fixed

2.4.8 14-Jun-18

Possibility to return String Types as Ansi or Unicode is added
Compatibility with MS Access is improved
Compatibility with Tableau is improved
Compatibility with Omnis Studio is improved
Compatibility with Power Pivot is improved
Compatibility with DBeaver is improved

2.3.7 26-Feb-18

Performance of batch operations is significantly improved
The SSHStoragePath connection parameter is added
Support for the use of "?", "?|" and "?&" JSON operators in SQL statements by escaping the question mark character ("\?", "\?|" and "\?&" respectively) is added

2.2.6 23-Oct-17

PostgreSQL 10 is supported
Azure Database for PostgreSQL is supported
Compatibility with SAS JMP is improved
Compatibility with MS Power Query is improved
OUTER JOIN macros in SQL queries are supported
DateTime macros in SQL queries are supported
Scalar function macros in SQL queries are supported

2.1.5 22-Jun-17

Compatibility with Adobe ColdFusion is improved
Several issues with data modification in Microsoft SQL Server Management Studio are resolved
Now "." is a decimal separator for numbers with floating point by default
Bug with handling the numeric data type is fixed

2.1.4 29-Nov-16

Compatibility with Microsoft SQL Server Reporting Services is improved

2.1.3 26-Oct-16

Compatibility with MS Visual Studio is improved
Compatibility with MS FoxPro is improved
Compatibility with MapInfo is improved
Compatibility with Libre Office is improved
Compatibility with Qlik is improved
Compatibility with Delphi & C++Builder is improved
MS Access linked tables support is improved
The SELECT ... FOR UPDATE statement is supported

2.0.2 05-Apr-16

Compatibility with MS Excel is improved
Compatibility with ODBC 2.x is improved
Bug with Trial expiration in Microsoft SQL Server Management Studio is fixed
Support for server versions 7.3-8.3 is improved
Bug with fetching big data amount is fixed

2.0.1 15-Mar-16

Linux is supported
macOS is supported
Support for stored procedures and functions is improved
Backward compatibility of SQLExecDirect with ODBC 2.x is improved

1.3.4 06-Jan-16

Connection via SSL protocol is supported
Connection via SSH protocol is supported
Connection via HTTP tunnel is supported
Compatibility with Microsoft Power BI Desktop is improved
Compatibility with Microsoft Visual FoxPro is improved

1.2.3 06-Nov-15

Compatibility with Microsoft Visual Studio is improved
Compatibility with Microsoft Office is improved
Compatibility with Microsoft SQL Server Management Studio is improved
Compatibility with Crystal Reports is improved
Compatibility with ClikView is improved
Compatibility with SQL Server Data Tools is improved

1.1.2 16-Jul-15

Performance is improved
Compatibility with SQL Server Data Tools Microsoft for Visual Studio 2013 is improved
Bug with access violation when using ADO is fixed
Bug with calling the same SQL statement for several times is fixed

1.0.1 20-May-15

Initial release of ODBC Driver for PostgreSQL
Windows 32-bit is supported
Windows 64-bit is supported