PostgreSQL
Connection Type | ODBC (64-bit) |
Type of Support | Read & Write; In-Database |
Validated On | Database Version: 11.7, 14.1, and 15.3. AWS RDS ODBC Client Version: 1.5.2.1002 |
For more information about the Simba PostgreSQL driver, see the Simba ODBC documentation.
Alteryx Tools used to Connect
Standard Workflow Process
In-Database Workflow Process
Select PostreSQL as the Data Source.
Supported Versions
Maximum Columns In Table: 250 - 1600, depending on column types
Maximum Column Name Length: 63 characters
Maximum Row Size: 1.6 TB
You can use either the ANSI 32-bit driver or the Unicode® ODBC driver. If using the ODBC connection for spatial data, use the Unicode® ODBC driver.
The driver does not support certain available JSONb query operators (?,?|,?&). For more information, see the PostgreSQL documentation.
Due to PostgreSQL database limitations, only two tables can be combined with the Union In-DB Tool that contain completely different column names. Three or more tables will produce an error.
To configure the PosgreSQL Bulk connection for writing data, please see the Configure PosgreSQL Bulk Connection for Writing Data article.
Known Limitations
Designer and Server may display the message "There is no Lua script, using generic ODBC" when connecting to PostgreSQL. This behavior is expected. The PostgreSQL Lua script is limited to DataWrap3, so connections using DataWrap2 correctly fall back to the generic ODBC driver.