send query in background

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
ml
Reply | Threaded
Open this post in threaded view
|

send query in background

ml
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


Reply | Threaded
Open this post in threaded view
|

Re: send query in background

Tatsuo Ishii-3
> 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)
>

You can use pg_send_query() of PHP.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp