What can be used in PostgreSQL to send messages to the front-end, and optionally terminate the current query being processed?



What can be used in PostgreSQL to send messages to the front-end, and optionally terminate the curre..

Answer / madhub

Select pg_terminate_backend(pid);

Select pg_cancel_backend(pid)

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Postgre Interview Questions

How do I change the order of columns in postgresql?

0 Answers  


How do I create a database in pgadmin 4?

0 Answers  


How many indexes per table are allowed in postgresql?

0 Answers  


Is postgres distributed?

0 Answers  


This message is received in response to the query SELECT * FROM JA_Party. I would like to know what am I doing wrong. ERROR: relation "ja_party" does not exist LINE 1: SELECT * FROM JA_Party ^ ********** Error ********** ERROR: relation "ja_party" does not exist SQL state: 42P01 Character: 15

1 Answers  


Where are postgres databases stored?

0 Answers  


How to setup postgresql sysv startup script?

0 Answers  


How are the stats updated in postgresql?

0 Answers  


Is mysql faster than postgresql?

0 Answers  


Is postgresql a sql server?

0 Answers  


Is postgresql better than oracle?

0 Answers  


What is composite primary key?

0 Answers  


Categories