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

Subscribe to our newsletter
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".
J Canepa: "There is a lot of software out there for managing PostgreSQL. Yours is simply the best! Great product".

More

Add your opinion

PostgreSQL Maestro online Help

Prev  Return to chapter overview Next 

Working with databases

After you have created the required database profiles (Create Database Profile Wizard) they appear in the explorer tree on the left. Now you can establish connection to the database. If connection succeeds, the database node expands displaying the tree of its objects.

 

Now you can perform all the necessary PostgreSQL admin routines such as creating, editing, copying, extracting and dropping database objects, design your database as ER diagram, build queries visually, execute queries and SQL scripts, accomplish database administration operations in a few mouse clicks, view and edit data including BLOBs, represent data as diagrams and pivot grids, analyze information summarized into OLAP cubes, export and import data to/from most popular file formats, manage server security features, and use a lot of other admin tools designed for making your work with PostgreSQL server comfortable and efficient.

 

 



Prev  Return to chapter overview Next