envvar

pig build pkg pg_envvar;		# build rpm/deb

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

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

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

CREATE EXTENSION envvar;

get_env(name TEXT) RETURNS TEXT

SELECT get_env('PGTZ');
-- UTC

SELECT get_env('HOME');
-- /var/lib/postgresql

SELECT get_env('PATH');
-- /usr/local/sbin:/usr/local/bin:...

SELECT get_env('NONEXISTENT');
-- NULL

CREATE SCHEMA env;
CREATE EXTENSION envvar SCHEMA env;

SELECT env.get_env('PGTZ');