pg_later

pig build pkg pg_later;		# build rpm/deb

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

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

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

shared_preload_libraries = 'pg_later';

CREATE EXTENSION pg_later CASCADE; -- requires pgmq

CREATE EXTENSION pg_later CASCADE;
SELECT pglater.init();

SELECT pglater.exec(
  'SELECT * FROM pg_available_extensions ORDER BY name LIMIT 2'
) AS job_id;

 job_id
--------
     1

SELECT pglater.fetch_results(1);

{
  "query": "select * from pg_available_extensions order by name limit 2",
  "job_id": 1,
  "result": [
    {
      "name": "adminpack",
      "comment": "administrative functions for PostgreSQL",
      "default_version": "2.1",
      "installed_version": null
    },
    {
      "name": "amcheck",
      "comment": "functions for verifying relation integrity",
      "default_version": "1.3",
      "installed_version": null
    }
  ],
  "status": "success"
}