Frontend Learning Book

AWS Redshift

Post in 四 30 十一月 2023 |Tags AWS

Encode

Amazon Redshift AZ64、LZO、ZSTD 字段的支持类型

Type Category	Type	LZO	SZTD	AZ64
SMALLINT	INT2	Yes	Yes	Yes
INTEGER	INT、INT4	Yes	Yes	Yes
BIGINT	INT8	Yes	Yes	Yes
DECIMAL	NUMERIC	Yes	Yes	Yes
REAL	FLOAT4	No	Yes	No
DOUBLE PRECISION	FLOAT、FLOAT8	No	Yes	No
BOOLEAN	BOOL	No	Yes	No
CHAR	CHARACTER、NCHAR、BPCHAR	Yes	Yes	No
VARCHAR	NVARCHAR、BPCHAR、TEXT	Yes	Yes	No
DATE、TIMESTAMP		Yes	Yes	Yes

Procedure

https://docs.amazonaws.cn/redshift/latest/dg/stored-procedure-create.html

CREATE OR REPLACE PROCEDURE pixonomy.test(source_table_name TEXT, destination_table_name TEXT)
AS $$
DECLARE
    input_row RECORD;
BEGIN
    FOR input_row IN EXECUTE 'SELECT * FROM ' || source_table_name LOOP
        EXECUTE
       'INSERT INTO ' || destination_table_name || ' SELECT ' || quote_literal(input_row.id);
    END LOOP;
END;
$$ LANGUAGE plpgsql;