Database Version: 9.4
Maximum Columns In Table: 250 - 1600, depending on column types
Maximum Column Name Length: 63 characters
Maximum Row Size: 1.6 TB
| Type of Support: | Read & Write; In-Database |
| Validated On: | Database version 9.4 ODBC client version 09.06.0310 |
| Connection Type: | ODBC (32- and 64-bit) |
| Driver Details: | The ODBC driver can be downloaded from PostgreSQL. In-Database processing requires 64-bit database drivers. |
Database Version: 9.4
Maximum Columns In Table: 250 - 1600, depending on column types
Maximum Column Name Length: 63 characters
Maximum Row Size: 1.6 TB
ODBC (Client Version: 9.03.04)
There are two options for the 32-bit driver: ANSI and UNICODE. Due to issues with the ANSI driver for spatial ODBC connections, you must use the UNICODE ODBC driver for spatial connections.
The driver does not support certain available JSONb query operators (?,?|,?&). For more information, see the PostgreSQL documentation.
In-Database
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.
©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.