I have 100 update queries, I run all in one go just pressing F5 on PGadmin query editor. But I only see "updated count" for the last query. How can I see the result message of all 100 update queries. If I see the message in Query History tab, it also shows only last message.
Although this is a very basic requirement to validate my data correction queries output before running on production. But I dont see any kind of help on google.
Please help, if there would be any other solution.
PGAdmin doesn't have such feature, I have tried a lot. But @Belayer comment helped me with alternate solution.
So we can achieve this by using DBeaver universal database tool
. Steps:
"DBeaver"
tool."Execute SQL Script (Alt+X)" option
to run them all together. DBeaver will execute query one after another till end and will keep displaying the result parallel in different window called "Execution Log".
We can see here number of row updated, Duration, Success or Fail status etc."Statistic"
that shows summary of the result of all the queries like number of total rows updated, Execution time etc.