postgresql 行转列

‘–行转列
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;