Data Integration Connectors
- Data Integration Connectors
- All Products
Aurora PostgreSQL Data Type
| Transformation Data Type
| Description
|
---|---|---|
integer
| integer
| -2147483648 to 2147483647, precision 10, scale 0
|
smallint
| integer
| -32768 to 32767, precision 10, scale 0
|
bigint
| bigint
| -9223372036854775808 to 9223372036854775807, precision 19, scale 0
|
real
| double
| Precision 15
|
float
| double
| Precision 15
|
double_precision
| double
| Precision 15
|
decimal
| decimal
| Precision 1 to 38, scale 0 to 38
|
numeric
| decimal
| Precision 1 to 38, scale 0 to 38
|
boolean
| string
| Precision 6
|
char
| string
| 1 to 10485760 characters
|
varchar
| string
| 1 to 10485760 characters
|
date
| date/time
| January 1, 0001, through December 31, 9999
|
time
| date/time
| 00:00:00.000 through 23:59:59.999
|
timestamp
| date/time
| Date range: January 1, 0001, through December 31, 9999 time range: 00:00:00 through 23:59:59.997
|
nchar
| string
| 1 to 10485760 characters
|