示例表:
Create table example(
id int ,
name varchar(50)
)
导出数据:
SELECT array_to_string(ARRAY( SELECT id ||',' || name FROM "AE_Major" ORDER BY "Id"),';')
导出数据还原为table格式:
SELECT aa[1] as id,aa[2] AS name FROM (SELECT regexp_split_to_array(regexp_split_to_table,',') AS aa FROM (SELECT * FROM regexp_split_to_table($0,';')) AS "tt" ) as "tt1"
$0为导出的字符串数据