pgsql

创建分区表： PostgreSQL分区表_pg分区表-CSDN博客

创建list分区的函数

create or replace function create_list_fq(tb_name char, row_name char)
returns int
AS $$
declares char;
beginraise notice 'CREATE TABLE if not exists %_% PARTITION OF %  FOR VALUES IN (''%'');', tb_name, row_name, tb_name, row_name;execute format('CREATE TABLE if not exists %s_%s PARTITION OF %s  FOR VALUES IN (''%s'');', tb_name, row_name, tb_name, row_name);raise notice '%, %', tb_name, row_name;return 123;
end;
$$
language plpgsql

获取字符串前面的非数字字符

create or replace function get_underlying(con text)
returns text as $$
DECLAREs text;current_char CHAR;index INT := 1;
BEGINcon := replace(con, 'SP ', '');WHILE index <= length(con) LOOPcurrent_char := SUBSTRING(con FROM index FOR 1);index := index + 1;if current_char >= '0' and current_char <= '9' thenexit;end if;s = concat(s, NULL, current_char);--RAISE INFO '当前字符s：%', s;END LOOP;return s;
END; $$
language plpgsql IMMUTABLE;