Online Documentation for SQL Manager for PostgreSQL

Database context menu

The context menu of a registered database in the DB Explorer tree allows you to:

• connect to the selected database (if connection to the database is not active yet);
• disconnect from the selected database (if connection to the database has been already activated);
• add the DDL of the database or of the objects it contains to the AI Assistant context;
• access database tools and services available in the Tasks submenu;
• access change management tools;
• view/edit the Database properties;
• view/edit the host properties within the Server Configuration dialog;
• create a new database at the host where the selected database resides;
• drop the selected database;
• register a new database or host using Register Database Wizard;
• view/edit the selected database registration information within the Database Registration Info dialog;
• unregister the selected database;
• view/edit the selected database registration information within the Database registration manager;
• generate the database script and open it in Query Data;
• generate the database script and copy its text to Windows clipboard;
• access View Mode options and configure representation of hosts and databases in Database Explorer;
• refresh the selected database;
• test connection to the database (or reconnect if connection has been already established);
• manage DB Explorer Tabs;
• search for database objects within the tree and continue searching, using the Search submenu;
• collapse all the nodes of the tree;
• expand all the nodes of the tree.

AI Assistant submenu allows you to:

• add the DDL of the database itself to the context with Add object DDL to chat;
• add the DDL of all the objects the database contains with Add subtree DDL to chat; what goes into the metadata snapshot is set on the Context tab.

Tasks submenu allows you to:

backup database using the wizard

restore database using the wizard

manage privileges

extract database objects and/or data to an SQL script

copy database objects and data to different location

print metadata

generate html report of the selected objects

create to-do list

analyze tables

vacuum tables

reindex database

database extensions

database statistics

Change Management submenu allows you to:

• create branch/label/tag using the wizard
• check repository using the wizard
• get change script using the wizard
• release new version of database using wizard
• browse history of object/database changes

View Mode submenu allows you to:

• show/hide table subobjects
• show/hide hosts
• sort databases by their aliases (by default databases are displayed due to their registration order)
• show/hide disconnected databases
• check table subobjects to display in SQL Assistant within the Tables' Details submenu
• check other subobjects to display in SQL Assistant within the Objects' Details submenu

Tabs submenu allows you to:

• create a new DB Explorer tab with the selected database/host only
• rename active tab
• delete active tab.