Contents

• pg_later
  • Installation
    • Run with docker
    • Using the extension
  • job_id
  • pg_later_results

pg_later

Execute SQL now and get the results later.

A postgres extension to execute queries asynchronously. Built on pgmq.

Installation

Run with docker

bash docker run -p 5432:5432 -e POSTGRES_PASSWORD=postgres quay.io/tembo/pglater-pg:latest

If you'd like to build from source, you can follow the instructions in CONTRIBUTING.md.

Using the extension

Initialize the extension's backend:

```sql CREATE EXTENSION pg_later CASCADE;

SELECT pglater.init(); ```

Execute a SQL query now:

```sql select pglater.exec( 'select * from pg_available_extensions order by name limit 2' ) as job_id;

job_id

 1

(1 row) ```

Come back at some later time, and retrieve the results by providing the job id:

```sql select pglater.fetch_results(1);

pg_later_results

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