《阿里云认证的解析与实战-数据仓库ACP认证》——云原生数据仓库AnalyticDB PostgreSQL版功能演示（上）——四、建表并导入数据

CREATE TABLE CUSTOMER(id int, name varchar, md5 varchar) DISTRIBUTED BY (id);

CREATE OR REPLACE FUNCTION f_random_str(length INTEGER)
RETURNS character varying AS $$
DECLARE
    result varchar(50);
BEGIN
    SELECT array_to_string(ARRAY(SELECT chr((65 + round(random() * 25)) :: integer)
    FROM generate_series(1,length)), '') INTO result;
    return result;
END;
$$ LANGUAGE plpgsql;

INSERT INTO customer SELECT *, f_random_str(5), md5(random()::text) FROM generate_series(1, 1000000);