Table of Contents generated with DocToc

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 ordinary tables and views.

Support for SQL in SQL query datasets

Only supports SELECT statements, supports all SELECT-related features provided by the connected PostgreSQL server, and users need to ensure syntax complies with PostgreSQL standards.

Supported PostgreSQL server authentication methods

Supports username and password methods, does not support SSL authentication.

Unsupported field types

The following types of columns in PostgreSQL tables cannot be correctly processed. If other fields of the table are needed, you can exclude these fields by typing the select statement in the SQL query.

  • interval
  • point
  • line
  • lseg
  • box
  • path
  • polygon
  • circle
  • macaddr
  • bit varying
  • tsquery
  • tsvector
  • xml
  • json
  • Arrays
  • Composite Types
  • Range Types