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
-
INTEGER
-
BIGINT
-
DECIMAL
-
NUMERIC
-
REAL
-
DOUBLE
-
CHAR
-
VARCHAR
-
TEXT
-
BYTEA
False
False
False
False
-
BOOLEAN
False
False
False
-
DATE
False
-
TIME
False
-
TIMESTAMP
False
-
INTERVAL
False
True*
True*
True*
-
JSON
True*
False
False
JSON / XML de-identification (Coming soon)
JSONB
True*
False
False
JSON / XML de-identification (Coming soon)
HSTORE
True*
True*
True*
True*
-
UUID
False
False
-
INET
False
True*
True*
True*
-
CIDR
False
True*
True*
True*
-
TSVECTOR
True*
True*
True*
True*
-
TSQUERY
True*
True*
True*
True*
-
POINT
False
True*
True*
True*
-
LSEG
False
True*
True*
True*
-
BOX
False
True*
True*
True*
-
PATH
False
True*
True*
True*
-
POLYGON
False
True*
True*
True*
-
LINE
False
True*
True*
True*
-
CIRCLE
False
True*
True*
True*
-
MONEY
-
OID
False
True*
True*
True*
-
BIT
-
BIT VARYING
-
ENUM
False
False
False
False
-
TSRANGE
False
True*
True*
True*
-
TSTZRANGE
False
True*
True*
True*
-
NUMRANGE
False
True*
True*
True*
-
INT4RANGE
False
True*
True*
True*
-
INT8RANGE
False
True*
True*
True*
-
INT4MULTIRANGE
False
True*
True*
True*
-
INT8MULTIRANGE
False
True*
True*
True*
-
XML
False
False
False
False
JSON / XML de-identification (Coming soon)(Content may be <blank>blank</blank>
if no rule applies.)
ARRAY INT
True*
True*
True*
True*
-
ARRAY VARCHAR
True*
True*
True*
True*
-
FLOAT
-
MACADDR
False
True*
True*
True*
-
MACADDR8
False
-
REGCONFIG
True*
True*
True*
True*
-
REGCLASS
False
True*
True*
True*
-
DATERANGE
False
True*
True*
True*
-