PostgreSQL 12.3 can be accessed via ODBC as any ODBC compliant RDBMS.
Make sure to download and install PostgreSQL 12.3 (or later), its accompanying management studio pgAdmin (https://www.postgresql.org/download/windows/) and its ODBC drivers (https://www.postgresql.org/ftp/odbc/versions/msi/) .
When configuring your ODBC Data Source, always set Use Declare/Fetch to OFF.
Also, the driver configuration Max_Rows_Fetched will be set to 100 and automatically added to tables’ INT files by default when creating new PostgreSQL tables or converting tables to PostgreSQL. That default may be changed by adjusting the Default_Max_Rows keyword in the backend’s configuration file (PostgreSQL.int) or its corresponding attribute, DF_DATABASE_DEFAULT_MAX_ROWS.
We advise using Max_Rows_Fetched to avoid performance issues and “out of memory” errors. When Max_Rows_Fetched is not used, Find GT/LT in PostgreSQL will be slow on large tables and may cause “out of memory” errors on extremely large tables.
Even if you are going to focus on 32-bit for your application, you must also install the 64-bit PostgreSQL ODBC driver because the DataFlex Studio and other DataFlex tools are 64 bits.