Online Documentation for SQL Manager for PostgreSQL

Using Navigation bar and Toolbar


The Navigation bar and Toolbar provide quick access to tools implemented in View Editor.

 

View Editor - Using Navigation barNEW

 

Object

iconDB select a database

iconObjects_View select a view for editing

 

General

iconCompile compile the view (if it is being created/modified)

iconSaveDescription save the view description (if it has been modified)

iconTools_QB edit the view query using Design Query

iconRefresh refresh the content of the active tab

iconPrint print metadata of the view

iconTools_DependencyTree view the dependency tree for the view

iconRestoreDefaultSize restore the default size and position of the editor window

 

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 the view:

 

Rules

iconObjects_AddRule add a new rule

iconObjects_EditRule edit selected rule

iconObjects_DropRule drop selected rule(s)

 

Triggers

iconObjects_AddTrigger add a new trigger

iconObjects_EditTrigger edit selected trigger

iconObjects_DropTrigger drop selected trigger(s)

 

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 data from the view using Export Data Wizard

iconTools_ExportAsSQLScript export data from the view as SQL script using Export as SQL Script Wizard

iconTools_ImportData import data

 

Materialized View

View Editor - Mat view refresh refreshes data of materialized view

View Editor - Mat view clear clears data of materialized view

 

Description

iconSaveToFile save object description to file

iconCopyToClipboard copy description to clipboard

 

DDL

iconSaveToFile save DDL to file

iconTools_SQLEditor open DDL in Query Data

 

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