PostgreSQL

Connections to a PostgreSQL database are made by selecting PostgreSQL from the list of drivers in the list of connectors in the QlikView ODBC Connection dialog or the Qlik Sense Add data or Data load editor dialogs.

Industry-accepted best practices must be followed when using or allowing access through the ODBC Connector. Administrators must follow The Principle of Least Privilege when setting up source database privileges and permissions.

Supported offerings

Qlik Sense Desktop/Qlik Sense Mobile Client Managed
Qlik Sense Business
Qlik Sense Enterprise on Windows
Qlik Sense Enterprise SaaS
QlikView (Requires separate installation)

Supported PostgreSQL versions

The followings data versions are supported:

9.4 - 9.6, 10, 11, 12, 13, 14

Supported PostgreSQL data types

The following PostgreSQL data types are supported by the PostgreSQL Connector.

Array
BigInt
BigSerial
Bit
Bit Varying
Boolean
Box
Char
Character Varying
Cid
Cidr
Circle
Composite Types
Date
DateRange
Double Precision
Enum
Inet
Int4Range
Int8Range
Integer
Interval
Json
JsonB
Line
LSeg
MacAddr
Money
Numeric
NumRange
Oid
Path
Pg_Lsn
Point
Polygon
Real
Serial
SmallInt
SmallSerial
Text
Tid
Time
Timestamp
Timestamp With Time Zone
TsQuery
TsRange
TstzRange
TsVector
Txid_Snapshot
Uuid
VarChar
Xid
XML

Learn more

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here