Query Tool¶
The Query Tool is a powerful, feature-rich environment that allows you to execute arbitrary SQL commands and review the result set. You can access the Query Tool via the Query Tool menu option on the Tools menu, or through the context menu of select nodes of the Object explorer control. The Query Tool allows you to:
Issue ad-hoc SQL queries.
Execute arbitrary SQL commands.
Edit the result set of a SELECT query if it is updatable.
Displays current connection and transaction status as configured by the user.
Save the data displayed in the output panel to a CSV file.
Review the execution plan of a SQL statement in either a text, a graphical format or a table format (similar to https://explain.depesz.com).
View analytical information about a SQL statement.
You can open multiple copies of the Query tool in individual tabs simultaneously. To close a copy of the Query tool, click the X of the tab.
... continue reading