wrobstory · August 25, 2016 20:10 · Aug 25, 2016
diff --git a/postgres_to_redshift.csv b/postgres_to_redshift.csv
@@ -0,0 +1,49 @@
+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)