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

Answer Posted / madhub

Select pg_terminate_backend(pid);

Select pg_cancel_backend(pid)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you delete a row in pgadmin 4?

448


What is the password of postgres user?

502


What is a sequence table in postgresql?

432


What is pgadmin used for?

454


What is difference between postgresql and mysql?

427






What is dummy table?

464


Is postgres distributed?

427


Provide an explanation about write ahead logging?

448


Does google use postgresql?

432


What are the types of stored procedures?

444


What is the difference between a primary key and a composite key?

416


List different advantages of postgresql?

490


What is pgrouting?

443


What is composite foreign key?

386


Does unique constraint create index postgres?

424