currency

pig build pkg pg_currency;		# build rpm/deb

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

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

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

CREATE EXTENSION currency CASCADE; -- requires plpgsql

CREATE EXTENSION currency;

CREATE TABLE transactions (
    id                serial,
    payment_currency  currency
);

INSERT INTO transactions VALUES (1, 'USD'), (2, 'EUR'), (3, 'USD');

SELECT * FROM transactions ORDER BY payment_currency;
 id | payment_currency
----+------------------
  2 | EUR
  1 | USD
  3 | USD

-- List all supported currency codes
SELECT * FROM supported_currencies() currency ORDER BY currency;