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

Subscribe to our news:
Partners
Testimonials
Simon Pills: "Someone finally invented an intuitively used and easily customized PostgreSQL database administration tool! Keep up the good work. I will be in touch. I am able to do this horrendous work because your software enabled me to create a new database with all necessary objects in several minutes! I am sure that I have found what I really need".
Shafiq Far: "Just wanted to let you know that I think the SQL Maestro for Postgres is excellent. We've tried a variety over the past few years and none are even close to yours. Well done".

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