emailaddr

pig build pkg pg_emailaddr;		# build rpm/deb

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

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

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

CREATE EXTENSION emailaddr;

CREATE EXTENSION emailaddr;

CREATE TABLE accounts (
    id    int PRIMARY KEY,
    name  text,
    email emailaddr
);

INSERT INTO accounts VALUES (1, 'Peter Eisentraut', '[email protected]');