Thread: send query in background
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
> 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