NOTE: The listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Access/Read

Source Data TypeSupported?

arrayN
bigintYInteger
bigserialYInteger
bit [ (n) ]YString
bit varying [ (n) ]YString
booleanYBool
boxYString
byteaYString
character varying(n), varchar(n)YString
character(n), char(n)YString
cidrYString
circleYString
compositeN
dateYDate
daterangeN
decimalYDecimal
double precisionYDecimal
enumN
inetYString
int4rangeN
int8rangeN
integerYInteger
interval [ fields ] [ (p) ]YString
jsonYObject
lineN
lsegYString
macaddrYString
moneyYDecimal
numericYDecimal/Integer
numrangeN
oidN
pathYString
pointYString
polygonYString
realYDecimal
serialYInteger
smallintYInteger
smallserialYInteger
textYString
time [ (p) ]YDate
time [ (p) ] with time zoneYString
timestamp [ (p) ]YDate
timestamp [ (p) ] with time zoneYDate
tsqueryYString
tsrangeN
tstzrangeN
tsvectorYString
txid_snapshotYString
uuidYString
xmlYString

Write/Publish

PostgreSQL Column TypeNotes
BoolBOOL

VARCHAR
IntegerBIGINT

INT

SMALLINT

VARCHAR
StringVARCHAR
DatetimeTIMESTAMP

VARCHAR
FloatDECIMAL

NUMERIC

VARCHAR
MapVARCHAR
ArrayVARCHAR


NOTE: If you are appending to an existing table where a column's is not mapped to the column data type in the target table, a validation error is thrown, as the writes unmapped types as String data type.