pg_csv

pig build pkg pg_csv         # 构建 RPM / DEB 包

pig repo add pgsql -u          # 添加仓库并更新缓存

CREATE EXTENSION pg_csv;

CREATE EXTENSION pg_csv;

CREATE TABLE projects AS SELECT * FROM (VALUES
  (1, 'Death Star OS', 1),
  (2, 'Windows 95 Rebooted', 1),
  (3, 'Project "Comma,Please"', 2)
) AS _(id, name, client_id);

-- 基本 CSV 输出
SELECT csv_agg(x) FROM projects x;
-- id,name,client_id
-- 1,Death Star OS,1
-- 2,Windows 95 Rebooted,1
-- 3,"Project ""Comma,Please""",2

-- 管道符分隔
SELECT csv_agg(x, csv_options(delimiter := '|')) FROM projects x;

-- 制表符分隔
SELECT csv_agg(x, csv_options(delimiter := E'\t')) FROM projects x;

-- 添加 BOM 以兼容 Excel
SELECT csv_agg(x, csv_options(bom := true)) FROM projects x;