Postgres --> Redshift types via http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Reference.Target.PostgreSQL.DataTypes.html
PostgreSQL Data Types | AWS DMS Data Types | Redshift Data Types | |
---|---|---|---|
INTEGER | INT4 | INT4 | |
SMALLINT | INT2 | INT2 | |
BIGINT | INT8 | INT8 | |
NUMERIC (p,s) | If precision is 39 or greater, then use STRING. | If the scale is => 0 and =< 37 then: NUMERIC (p,s) If the scale is => 38 and =< 127 then: VARCHAR (Length) | |
DECIMAL(P,S) | If precision is 39 or greater, then use STRING. | If the scale is => 0 and =< 37 then: NUMERIC (p,s) If the scale is => 38 and =< 127 then: VARCHAR (Length) | |
REAL | REAL4 | FLOAT4 | |
DOUBLE | REAL8 | FLOAT8 | |
SMALLSERIAL | INT2 | INT2 | |
SERIAL | INT4 | INT4 | |
BIGSERIAL | INT8 | INT8 | |
MONEY | Note: The MONEY data type is mapped to FLOAT in SQL Server. | VARCHAR(108) (largest serialized value is “-$92,233,720,368,547,758.08”, 28 chars) | |
CHAR | WSTRING (1) | NVARCHAR(1) | |
CHAR(N) | WSTRING (n) | If the length is => 1 and =< 65535 then: NVARCHAR (Length in Bytes) If the length is => 65536 and =< 2147483647, then: NVARCHAR (65535) | |
VARCHAR(N) | WSTRING (n) | If the length is => 1 and =< 65535, then: NVARCHAR (Length in Bytes) If the length is => 65536 and =< 2147483647, then: NVARCHAR (65535) | |
TEXT | NCLOB | NVARCHAR(65535) | |
BYTEA | BLOB | VARCHAR(MAX) | |
TIMESTAMP | TIMESTAMP | If the scale is => 0 and =< 6, then: TIMESTAMP (s) If the scale is => 7 and =< 9, then: VARCHAR (37) | |
TIMESTAMP (z) | TIMESTAMP | If the scale is => 0 and =< 6, then: TIMESTAMP (s) If the scale is => 7 and =< 9, then: VARCHAR (37) | |
TIMESTAMP with time zone | Not supported | ||
DATE | DATE | DATE | |
TIME | TIME | VARCHAR(20) | |
TIME (z) | TIME | VARCHAR(20) | |
INTERVAL | STRING (128)—1 YEAR, 2 MONTHS, 3 DAYS, 4 HOURS, 5 MINUTES, 6 SECONDS | VARCHAR(128) | |
BOOLEAN | STRING (1) F or T | VARCHAR(1) | |
ENUM | STRING (64) | VARCHAR(64) | |
CIDR | STRING (50) | VARCHAR(50) | |
INET | STRING (50) | VARCHAR(50) | |
MACADDR | STRING (18) | VARCHAR(18) | |
BIT (n) | STRING (n) | VARCHAR(n) | |
BIT VARYING (n) | STRING (n) | VARCHAR(n) | |
UUID | STRING | CHAR(36) | |
TSVECTOR | CLOB | VARCHAR(MAX) | |
TSQUERY | CLOB | VARCHAR(MAX) | |
XML | CLOB | VARCHAR(MAX) | |
POINT | STRING (255) "(x,y)" | VARCHAR(255) | |
LINE | STRING (255) "(x,y,z)" | VARCHAR(255) | |
LSEG | STRING (255) "((x1,y1),(x2,y2))" | VARCHAR(255) | |
BOX | STRING (255) "((x1,y1),(x2,y2))" | VARCHAR(255) | |
PATH | CLOB "((x1,y1),(xn,yn))" | VARCHAR(MAX) | |
POLYGON | CLOB "((x1,y1),(xn,yn))" | VARCHAR(MAX) | |
CIRCLE | STRING (255) "(x,y),r" | VARCHAR(255) | |
JSON | NCLOB | VARCHAR(MAX) | |
ARRAY | NCLOB | VARCHAR(MAX) | |
COMPOSITE | NCLOB | VARCHAR(MAX) | |
INT4RANGE | STRING (255) | VARCHAR(255) | |
INT8RANGE | STRING (255) | VARCHAR(255) | |
NUMRANGE | STRING (255) | VARCHAR(255) | |
STRRANGE | STRING (255) | VARCHAR(255) |
This comment has been minimized.
This comment has been minimized.
Boolean is now supported in Redshift. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This comment has been minimized.
Treating numbers as strings seems like a horrible idea...