PgAdmin 4 - how to see output message of every query

user_4944711 0
Viewed 1077

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-4 postgresql
1 Answers

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:

  1. download and install free "DBeaver" tool.
  2. create connection with your database.
  3. paste your all the queries in query script editor, and use "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.
  4. DBeaver has one another window called "Statistic" that shows summary of the result of all the queries like number of total rows updated, Execution time etc.
user_49447110
Related