-- 将 AQY_ID,AQY 中的字符串拆分为多行
SELECT
"ID",
"AQY_ID",
"AQY",
UNNEST ( string_to_array( "AQY_ID", ',' ) ) AS "AQY_ID_1",
UNNEST ( string_to_array( "AQY", ',' ) ) AS "AQY_1"
FROM
"JF_SGCF"
效果如下:
-- 将 AQY_ID,AQY 中的字符串拆分为多行
SELECT
"ID",
"AQY_ID",
"AQY",
UNNEST ( string_to_array( "AQY_ID", ',' ) ) AS "AQY_ID_1",
UNNEST ( string_to_array( "AQY", ',' ) ) AS "AQY_1"
FROM
"JF_SGCF"
效果如下: