bzip

pig build pkg pg_bzip;		# build rpm/deb

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

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

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

CREATE EXTENSION bzip;

SELECT convert_from(bzcat(pg_read_binary_file('/path/to/data.csv.bz2')), 'utf8') AS contents;

SELECT bzip2(repeat('my text to be compressed', 1000)::bytea) AS compressed;

SELECT bzip2('some data'::bytea, 5);