Online Documentation for SQL Manager for PostgreSQL

Using Navigation bar and Toolbars

The Navigation bar and Toolbars provide quick access to tools implemented in Database Designer.

 

 

 

Database

select a database for building the diagram

 

File group

create a new diagram;

open an existing diagram;

save the current diagram to a *.pgd file;

save the current diagram as a custom file

 

Navigator

use Diagram Navigator

 

General group

cancel latest modification;

repeat canceled modification;

refresh objects in the diagram;

Print setup - define printing settings;

print the diagram;

show Print Preview;

edit diagram options

restore the default size and position of the window

Pages group:

add a new page;

delete the current page;

delete all pages.

 

Database Objects

 

 

contains the list of objects (tables, views and functions) that can be placed to diagram.

Context menu of Database Objects group allows you to:

search for objects in the diagram using the Database Objects pane;

add objects to the diagram using the Database Objects pane;

switch objects view: As tree/As list;

enable/disable sorting by schema, object name or object name, schema;

refresh list of objects.

 

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

 

The main toolbar (by default, the toolbar is located at the top of the diagram area) contains a number of tools (including items of the Navigation bar, context menu, tools for printing diagram, etc.) allowing you to:

select the database for building the diagram;

create a new diagram;

open an existing diagram;

save the current diagram to a *.pgd file;

save the current diagram as an image;

activate the Incremental search panel;

• adjust diagram zoom for optimal representation: zoom in, zoom out, fit model;

switch cursor mode: select / select rectangle to fit;

open the Print Setup dialog;

print the diagram;

show Print Preview;

arrange objects in the diagram;

extract metadata of all objects in the diagram and load the script to Execute Script Editor;

perform Reverse Engineering;

refresh objects in the diagram;

view/edit diagram options;

• specify a predefined zoom value;

restore the default size and position of the window.

 

Object Customization panel allows you to define font, font size, font style, font color and brush color.

 

 

The Pages toolbar (by default, the toolbar is located at the top of the diagram area) contains tools for working with diagram pages allowing you to:

add a new page;

delete the current page;

delete all pages.

 

Diagram toolbar located on the left allows you to:

switch to object selection mode;

switch to create table mode (enables creating tables on clicking);

switch to create relation mode;

switch to create virtual relation mode;

switch to create comment mode;

align left edges;

align right edges;

align tops;

align bottom;

align horizontal centers;

align vertical centers;

space equally, horizontal;

space equally, vertical.

 

The New object toolbar (by default, the toolbar is located on the left side of the diagram area) allows you to:

• set the cursor mode to Select;
• create a new object (a table or a comment);
• create a new relation;

 

 

---