‘–行转列
with tmp_table as (
select ‘a’ name1,‘A,B,C,D’::varchar as t
)
select name1,regexp_split_to_table(t,’,’) t
from tmp_table;
postgresql 行转列
最新推荐文章于 2024-04-25 13:24:35 发布
‘–行转列
with tmp_table as (
select ‘a’ name1,‘A,B,C,D’::varchar as t
)
select name1,regexp_split_to_table(t,’,’) t
from tmp_table;