PostgreSQL
Last updated
Was this helpful?
Last updated
Was this helpful?
Before you begin, gather this connection information:
Name of the server that hosts the database you want to connect to
Database name
User name and password
Are you connecting to an SSL server?
Launch Syntho and select Connect to a database, or under Create workspace, select PostgreSQL. For a complete list of data connections, select More under From database. Then do the following:
Enter the name of the server that hosts the database that you want to connect to.
Enter the database name to connect to the contained database.
Enter the port number.
Enter user name and password.
Select the Require SSL check box when connecting to an SSL server.
Select Create Workspace. If Syntho can't make the connection, verify that your credentials are correct. If you still can't connect, your computer is having trouble locating the server. Contact your network administrator or database administrator.
For JSON and XML columns, turn off validation in target and/or enable ALTER permission for user.
This table outlines the support and limitations for various data types in PostgreSQL when using connectors. It indicates what's supported per generator type, and if any additional processing is performed by Syntho to successfully generate and write the data.
SMALLINT
discrete
-
INTEGER
discrete
-
BIGINT
discrete
-
DECIMAL
continuous
-
NUMERIC
continuous
-
REAL
continuous
-
DOUBLE
continuous
-
CHAR
categorical
-
VARCHAR
categorical
-
TEXT
categorical
-
BYTEA
bytes
False
False
False
False
-
BOOLEAN
bool
False
False
False
-
DATE
datetime
False
-
TIME
datetime
False
-
TIMESTAMP
datetime
False
-
INTERVAL
no active support
False
True
True
True
-
JSON
json
True
False
False
JSON / XML de-identification (Coming soon)
JSONB
json
True
False
False
JSON / XML de-identification (Coming soon)
HSTORE
no active support
True
True
True
True
-
UUID
uuid
False
False
-
INET
no active support
False
True
True
True
-
CIDR
no active support
False
True
True
True
-
TSVECTOR
no active support
True
True
True
True
-
TSQUERY
no active support
True
True
True
True
-
POINT
no active support
False
True
True
True
-
LSEG
no active support
False
True
True
True
-
BOX
no active support
False
True
True
True
-
PATH
no active support
False
True
True
True
-
POLYGON
no active support
False
True
True
True
-
LINE
no active support
False
True
True
True
-
CIRCLE
no active support
False
True
True
True
-
MONEY
continuous
-
OID
no active support
False
True
True
True
-
BIT
discrete
-
BIT VARYING
discrete
-
ENUM
sets
False
False
False
False
-
TSRANGE
no active support
False
True
True
True
-
TSTZRANGE
no active support
False
True
True
True
-
NUMRANGE
no active support
False
True
True
True
-
INT4RANGE
no active support
False
True
True
True
-
INT8RANGE
no active support
False
True
True
True
-
INT4MULTIRANGE
no active support
False
True
True
True
-
INT8MULTIRANGE
no active support
False
True
True
True
-
XML
no active support
False
False
False
False
JSON / XML de-identification (Coming soon)(Content may be <blank>blank</blank>
if no rule applies.)
ARRAY INT
no active support
True
True
True
True
-
ARRAY VARCHAR
no active support
True
True
True
True
-
FLOAT
continuous
-
MACADDR
no active support
False
True
True
True
-
MACADDR8
categorical
False
-
REGCONFIG
no active support
True
True
True
True
-
REGCLASS
no active support
False
True
True
True
-
DATERANGE
no active support
False
True
True
True
-
Data types that are labeled as "no active support" mean that they are not actively supported, however, you may still be able to apply generators (e.g., AI-powered generation, mask, mockers or calculated columns) to these columns. Duplication is fully supported for these types.