Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Iwan Kelaiah: "SQL Maestro products (Postgresql) have saved me a lot of time in designing, managing and generating reports and front-ends of Postgresql databases. Keep up the great work and thank you for such great products.".
J Canepa: "There is a lot of software out there for managing PostgreSQL. Yours is simply the best! Great product".

More

Add your opinion

SQL Maestro Group / Products / PostgreSQL / PostgreSQL Maestro / Product tour / Database Objects Management

PostgreSQL Maestro: Product Tour

Features of PostgreSQL Maestro:

Database Objects Management

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.

Back Next