From: Franz Timmer <ftimmer@ft-c.de>
Reply-To: ml@ft-c.de
To: pgsql-sql@lists.postgresql.org
Subject: send query in background
Message-ID: <44c27f2a-d010-fb71-5410-359f75475660@ft-c.de>
Date: Fri, 9 Oct 2020 06:31:49 +0200
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:68.0) Gecko/20100101
 Thunderbird/68.12.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: de-DE
Content-Transfer-Encoding: 7bit
Precedence: bulk

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