Online Documentation for SQL Manager for PostgreSQL

Using Navigation bar and Toolbar

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


Table Editor - Using Navigation bar




iconDB select a database

iconObjects_Table select a table for editing



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

iconRefresh refresh the content of the active tab

iconPrint print metadata of the table

iconOptions adjust Table Editor options

iconRestoreDefaultSize restore the default size and position of the editor window



iconServices_AnalyzeTables analyze and vacuum the table

iconTools_ClusterTable cluster the table indexes

iconTools_TruncateTable truncate data of the table

iconTools_Reindex reindex the table indexes

iconObjects_CreateView create a view based on the table

iconTools_DependencyTree view the dependency tree for the table



iconDBExplorer browse the table subobjects using the Explorer tree


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



iconObjects_AddField add a new column

iconObjects_EditField edit selected column

iconObjects_DropField drop selected column(s)


Foreign keys

iconObjects_AddFK add a new foreign key

iconObjects_EditFK edit selected foreign key

iconObjects_DropFK drop selected foreign key(s)



iconObjects_AddCheck add a new check

iconObjects_EditCheck edit selected check

iconObjects_DropCheck drop selected check(s)



iconObjects_AddIndex add a new index

iconObjects_EditIndex edit selected index

iconObjects_DropIndex drop selected index(-es)



iconObjects_AddTrigger add a new trigger

iconObjects_EditTrigger edit selected trigger

iconObjects_DropTrigger drop selected trigger(s)



iconObjects_AddRule add a new rule

iconObjects_EditRule edit selected rule

iconObjects_DropRule drop selected rule(s)



Table Editor - Policies New add a new policy

Table Editor - Policies Edit edit selected policy

Table Editor - Policies Drop drop selected policy(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 table using Export Data Wizard

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

iconTools_ImportData import data into the table using Import Data Wizard

iconTools_SaveData save data

iconTools_LoadData load data



iconSaveToFile save object description to file

iconCopyToClipboard copy description to clipboard



iconSaveToFile save DDL to file

iconTools_SQLEditor open DDL in Query Data


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