Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

   
Source Data TypeSupported?

D s item
itemData 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

...

D s item
itemData Type

PostgreSQL Column TypeNotes
BoolBOOL 

 VARCHAR 
IntegerBIGINT  

INT  

SMALLINT 

 VARCHAR 
StringVARCHAR 
DatetimeTIMESTAMP 

 VARCHAR 
TimestampVARCHAR 

FloatDECIMAL 

 NUMERIC  

VARCHAR 
MapVARCHAR 
ArrayVARCHAR 


Info

NOTE: If you are appending to an existing table where a column's

D s item
itemdata 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.

...