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.


Query Builder - Using Navigation bar




iconDB select a database for the query



iconExecute execute the current query

iconQueries_ExplainQuery view estimated query execution plan

iconQueries_RemoveQuery clear the query

iconObjects_CreateView create a view

iconOptions configure Design Query with the Design Query Options page of the Environment Options dialog

iconRestoreDefaultSize restore the default size and position of the builder window



iconDBExplorer 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:


Visual Builder

iconLoadFromFile load a diagram from a *.vqb file using the Open diagram dialog

iconSaveToFile save the diagram to a *.vqb file using the Save diagram as... dialog



iconLoadFromFile load a query from an *.sql file using the Open SQL File dialog

iconSaveToFile save the query to an *.sql file


Data Management

iconCommit commit transaction

iconRollback rollback transaction

Note: These actions are available if the CheckBox Use transactions in object editors, Query Data and Design Query option is checked in the Database Registration Info | Data options dialog.

iconTools_ExportData export the returned dataset using Export Data Wizard

iconTools_ExportAsSQLScript 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.