postgresql数据导出与导入(批量进行数据更新和维护)

示例表：

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为导出的字符串数据