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

Can postgres scale horizontally?

0 Answers  


How do I change the order of columns in postgresql?

0 Answers  


How to take backup of database?

1 Answers  


How do I change the default postgres password?

0 Answers  


Is foreign key should be unique?

0 Answers  






What is default password for postgres?

0 Answers  


How to set up local postgres database?

0 Answers  


Where is pg_hba conf file?

0 Answers  


What is composite foreign key?

0 Answers  


What is dummy table?

0 Answers  


Does PostgrSQL support Column constraints? If so how is it done?

0 Answers  


Where is psql data stored?

0 Answers  


Categories