omni_csv

pig build pkg omnigres;		# build rpm/deb

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

pig install omnigres;		# install via package name, for the active PG version
pig install omni_csv;		# install by extension name, for the current active PG version

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

CREATE EXTENSION omni_csv;

SELECT * FROM omni_csv.csv_info(E'name,age,city\nJohn,25,NYC\nJane,30,LA');
-- Returns: name, age, city (one row per column)

SELECT * FROM omni_csv.parse(E'name,age,city\nJohn,25,NYC\nJane,30,LA')
    AS t(name text, age text, city text);

SELECT omni_csv.csv_agg(t)
FROM (SELECT name, age, city FROM employees ORDER BY name) t;