PostgreSQL Maestro: Product Tour

Database Explorer is the basic feature of PostgreSQL Maestro which allows you to perform all necessary operations upon databases and their objects.

Database Explorer field occupies the left side of PostgreSQL Maestro main window. Use it to create new database objects, duplicate, rename objects, and open object editors.

Within the explorer tree you can view schema scope (e.g. tables), database scope (e.g. extensions), and server scope objects (like roles or tablespaces).

PostgreSQL Maestro provides you with powerful tools to manage database objects. Wizards and editors designed for creating, editing and dropping database objects in different ways are at your disposal.

The Create Database Object dialog allows you to select the type of the object to be created and run the appropriate wizard (or open the appropriate dialog).

To open the dialog, select the Object | Create Database Object... main menu item.

The Duplicate Object Wizard allows you to create a new database object with the same properties as one of the existing objects has.

Select the Object | Duplicate Database Object... main menu item to run the wizard.

Another notable tool for database object management is Object Manager. This tool allows you to select multiple objects and then copy their SQL definitions to clipboard or drop selected objects. It is also possible to drag-and-drop objects between Object Manager and Database Explorer as well as between two instances of Object Manager.