send query in background - Mailing list pgsql-sql

From Franz Timmer
Subject send query in background
Date
Msg-id 44c27f2a-d010-fb71-5410-359f75475660@ft-c.de
Whole thread Raw
List pgsql-sql
hallo,

I have one pg function (a long running sql query), it is running few 
minutes. I start it from webserver via PHP.

My question: Is there a possibility, that this function runs in 
background. PG send back a immidiately return and do the work after this 
answer.

like linux/bash commands with an ampersand "&" at the and of the line. 
The user get a prompt and can prozess his work.

When the user push the button on the website to start the sql-script, he 
can process his work.

I work with v11.8, but it is possible to update to v12.
(google found some answers, but these a 10 years old)

Franz



pgsql-sql by date:

Previous
From: p.sun.fun@gmail.com
Date:
Subject: Re: libpq CREATE DATABASE operation from multiple treads
Next
From: ml@ft-c.de
Date:
Subject: send query in background