Supported PostgreSQL Server Versions
9.2, 9.3, 9.4, 9.5, 9.6, 10.4
Encoding Support
Automatic encoding conversion
Connection Preview Support
Supports regular tables and views.
SQL Query Dataset Support for SQL
Only SELECT statements are supported, with all SELECT-related features supported by the connected PostgreSQL server. Users need to ensure the syntax complies with PostgreSQL standards.
PostgreSQL Server Authentication Method Support
Supports username and password authentication methods, but does not support SSL authentication methods.
Unsupported Field Types
The following types of columns in PostgreSQL tables cannot be processed correctly. If other fields from this table are needed, you can input a SELECT statement in the SQL query, excluding this field.
- interval
- point
- line
- lseg
- box
- path
- polygon
- circle
- macaddr
- bit varying
- tsquery
- tsvector
- xml
- json
- Arrays
- Composite Types
- Range Types