pg_csv

pig build pkg pg_csv;		# build rpm/deb

pig repo add pgsql -u   # add both repo and update cache

pig install pg_csv;		# install via package name, for the active PG version

pig install pg_csv -v 18;   # install for PG 18
pig install pg_csv -v 17;   # install for PG 17
pig install pg_csv -v 16;   # install for PG 16
pig install pg_csv -v 15;   # install for PG 15
pig install pg_csv -v 14;   # install for PG 14

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);

-- Basic CSV output
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

-- Pipe-separated values
SELECT csv_agg(x, csv_options(delimiter := '|')) FROM projects x;

-- Tab-separated values
SELECT csv_agg(x, csv_options(delimiter := E'\t')) FROM projects x;

-- With BOM for Excel compatibility
SELECT csv_agg(x, csv_options(bom := true)) FROM projects x;