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" }