Online Documentation for SQL Manager for PostgreSQL

Using Navigation bar and Toolbar


The Navigation bar and Toolbar provide quick access to tools implemented in Query Data.

 

SQL Editor - Using Navigation bar

 

 

Database

iconDB select a database for the query

 

General

iconExecute execute the current query

iconQueries_ExplainQuery view estimated query execution plan

iconTools_QB run Design Query to design the query as a diagram

iconQueries_ResultsMode switch the results representation mode: on Edit tab or on separate tab

iconOptions configure Query Data editor at Environment Options dialog

iconRestoreDefaultSize restore the default size and position of the editor window

iconDisableAllCodeFeatures disable/enable all code features

 

Queries

iconQueries_AddNewQuery add a new query (note that the current query text will not be lost)

iconQueries_RenameQuery rename the current query

iconQueries_RemoveQuery remove the query

iconQueries_RemoveAllQueries remove all queries from the editor

iconQueries_AddToFavoriteQueries edit the query text using Favorites editor and add the query to the Favorite Queries list

 

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:

 

Edit

iconFindText activate the Find Text dialog

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

iconSaveToFile save the query to an *.sql file

iconSaveToFileAs save the query to an *.sql file using the Save as... dialog

iconSaveAll save all queries to an *.sql file

 

Logs

iconFindText activate the Find Text dialog

iconSaveToFile save the query log to a file

iconLogs_ClearLog clear logs

 

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

iconTools_ImportData import data

 

NB: You can enable\disable Toolbars and Navigation bars at Environment options.