pg_tle

pig build pkg pg_tle         # build RPM / DEB packages

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

shared_preload_libraries = 'pg_tle';

CREATE EXTENSION pg_tle;

shared_preload_libraries = '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');