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

What is unlogged table?

426


What is foreign key violation?

428


What is difference between postgresql and mysql?

418


Why do we need connection pooling?

417


Does postgresql have a gui?

387






What is default password for postgres?

435


How do I enable remote access to postgresql database?

391


What is pg_hba conf file?

431


What does postgresql mean?

426


How is data stored in postgresql?

456


How do you insert rows and columns?

401


Do provide an explanation for pgadmin?

449


How do I create a table in postgresql pgadmin?

439


How do I alter a column in postgresql?

395


What is postgresql database cluster?

447