Postgres Data Type Conversions

Feature Availability: This feature is available in Cloud Dataprep Premium by TRIFACTA® INC.

NOTE: The Cloud Dataprep data types 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?

Cloud Dataprep Data Type

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

Cloud Dataprep Data Type

PostgreSQL Column TypeNotes
BoolBOOL
VARCHAR
IntegerBIGINT
INT
SMALLINT
VARCHAR
StringVARCHAR
DatetimeTIMESTAMP
VARCHAR
TimestampVARCHAR
FloatDECIMAL
NUMERIC
VARCHAR
MapVARCHAR
ArrayVARCHAR

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