PostgreSQL

Connections to a PostgreSQL database are made by selecting PostgreSQL from the list of drivers in the list of connectors in 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 PostgreSQL versions

The followings data versions are supported:

11, 12, 13, 14, 15

Supported PostgreSQL data types

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

Array
BigInt
BigSerial
Bit
Bit Varying
Boolean
Box
Bytea
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

Bu sayfa size yardımcı oldu mu?

Bu sayfa veya içeriği ile ilgili bir sorun; bir yazım hatası, eksik bir adım veya teknik bir hata bulursanız, bize bildirin, düzeltelim!

Geri bildiriminizi buradan iletin