pg_tle

pig build pkg pg_tle;		# build rpm/deb

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

pig install pg_tle;		# install via package name, for the active PG version

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

shared_preload_libraries = 'pg_tle';

CREATE EXTENSION pg_tle;

SELECT pgtle.install_extension(
  'my_extension',      -- extension name
  '1.0',               -- version
  'My custom extension', -- description
  $_pgtle_$
    CREATE FUNCTION my_func() RETURNS text AS $$
      SELECT 'hello from my_extension';
    $$ LANGUAGE SQL;
  $_pgtle_$
);

-- Add an upgrade path
SELECT pgtle.install_update_path(
  'my_extension',  -- extension name
  '1.0',           -- from version
  '1.1',           -- to version
  $_pgtle_$
    CREATE OR REPLACE FUNCTION my_func() RETURNS text AS $$
      SELECT 'hello from my_extension v1.1';
    $$ LANGUAGE SQL;
  $_pgtle_$
);

-- Set default version
SELECT pgtle.set_default_version('my_extension', '1.1');

CREATE EXTENSION my_extension;
SELECT my_func();  -- 'hello from my_extension'
ALTER EXTENSION my_extension UPDATE TO '1.1';

DROP EXTENSION my_extension;
SELECT pgtle.uninstall_extension('my_extension');

SELECT pgtle.register_feature('my_password_check', 'passcheck');
SELECT pgtle.unregister_feature('my_password_check', 'passcheck');