You can send SQL queries to the connected PostgreSQL database and display the result. The queries
can contain any possible statements, e.g. UPDATE, DELETE, INSERT, SELECT statements etc. Note, that it is possible to
run multiple SQL queries simultaneously.
The result of the SELECT-containing queries will be shown in the grid-based dialogues.
To execute SQL queries:
Connect to the database using
Database Connection Manager or
Use the already established database connection.
Call the SQL Executor by selecting Database | SQL Executor menu item or
pressing Ctrl-Shift-E.
Enter one or more SQL queries.
Click the Validate SQL button on the dialog window toolbar to check
your queries. Database Designer Validator can check SQL only for grammar corectness. This
means that it can't check corectness of the database objects name using, i.e. if you've been mistaken
in the name of some table. However, you may execute an SQL without validating it: it will be checked
before executing automatically.
Press F9 or click the Execute SQL button on the dialog window toolbar to execute
your queries. A data grid window will be displayed for each SELECT-based query. To close the data
grid window, click on the Close button. The execution status for each query will be displayed at
the bottom of the SQL Executor dialog window.
You can save your queries into a file. Click on the Save
() button on the
SQL Executor toolbar.