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