Online Documentation for SQL Manager for PostgreSQL
Using Navigation bar and Toolbar
The Navigation bar and Toolbar provide quick access to tools implemented in Design Query.
select a database for the query
execute the current query
view estimated query execution plan
clear the query
create a view
restore the default size and position of the builder window
browse objects of the database; you can also add tables and views to the diagram using drag-and-drop operations
Depending on the current tab selection, the Navigation bar expands to one or more additional panes with tab-specific actions that can be useful for working with queries:
load a diagram from a *.vqb file using the Open diagram dialog
save the diagram to a *.vqb file using the Save diagram as... dialog
load a query from an *.sql file using the Open SQL File dialog
save the query to an *.sql file
Note: These actions are available if the Use transactions in object editors, Query Data and Design Query option is checked in the Database Registration Info | Data options dialog.
export the returned dataset using Export Data Wizard
export the returned dataset as SQL Script using the Export as SQL Script wizard
NB: You can enable\disable Toolbars and Navigation bars at Environment options.