逗号分隔字符串,转换成一列
--源数据:'c6d4eed5,7e51b2d9,768db3f1,7cc464bb'
--函数:regexp_split_to_table
SELECT regexp_split_to_table('c6d4eed5,7e51b2d9,768db3f1,7cc464bb',',')
逗号分隔字符串,转换成数组
--源数据:'c6d4eed5,7e51b2d9,768db3f1,7cc464bb'
--函数:regexp_split_to_array
SELECT regexp_split_to_array('c6d4eed5,7e51b2d9,768db3f1,7cc464bb',',') AS data
列转换成数组
--函数:ARRAY_AGG
SELECT ARRAY_AGG(columndata) AS data
FROM table
数组转换成字符串
--函数:array_to_string
SELECT array_to_string(ARRAY_AGG(display_name),'/')
FROM table
标签:函数,--,PGSQL,c6d4eed5,table,array,SELECT,7e51b2d9
From: https://www.cnblogs.com/eago/p/17930663.html