VI

Database

SQL Maestro PostgreSQL Maestro 23.9.0.1 Multilingual

Use PostgreSQL Maestro to administer any PostgreSQL server version from 7.3 to 9.3! PostgreSQL Maestro supports last server version features such as PL/pgSQL Debugger, role system, parameter scopes, connection limits, tablespaces, changing...

Description

Use PostgreSQL Maestro to administer any PostgreSQL server version from 7.3 to 9.3! PostgreSQL Maestro supports last server version features such as PL/pgSQL Debugger, role system, parameter scopes, connection limits, tablespaces, changing column types, dollar-quotation, Unicode data and much more. Tune up your PostgreSQL server security policy with several mouse clicks. PostgreSQL Maestro provides you with a number of powerful GUI editors that make management of Postgres users, roles and their privileges (grants) as easy as it can be, even if you are not a skilled PostgreSQL administrator.

PostgreSQL Maestro is the premier PostgreSQL GUI admin tool for database management, control and development. Key features include:

Support for all the PostgreSQL server versions from 7.3

Easy database object management

Database Designer

PL/pgSQL Debugger

Comfortable access to PostgreSQL security features

Data management: editing, grouping, sorting and filtering abilities

Handy SQL Editor with code folding and multi-threading

Visual Query Builder with support for subqueries and UNIONS

Working with remote PostgreSQL servers via SSH or HTTP tunnel

Data export/import to/from the most popular formats

Powerful BLOB Viewer/Editor

As PostgreSQL client for Windows, PostgreSQL Maestro lets you use Windows clipboard, drag-and-drop operations, and local pop-up menus for database objects. For example, to copy an object, simply drag and drop the object from one database to another, or use the Ctrl+C and Ctrl+V shortcuts instead of performing a long succession of manual operations.

PostgreSQL Maestro GUI is as easy in use as Windows explorer! PostgreSQL Maestro provides you with an understandable "explorer-like" navigation style, well-described wizard system, quick launch panel and a lot of other tools and features which do not require deep knowledge of PostgreSQL.

Handy SQL Editor provides you with an ability to execute several queries simultaneously. Each query is executed in a separate thread, so all PostgreSQL Maestro opportunities remain available and there is no need to wait for your complex query to be completed. Such features as syntax highlighting and code completion make your work with the Editor extremely comfortable.

PostgreSQL Maestro supports more than twelve formats for data export and six formats for data import. These are MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, CSV, DBF and more. Moreover, the Postgres client does not require any additional software installed for all the supported formats.

Using PostgreSQL Maestro manager you can view or edit BLOB data in the following ways: hexadecimal dump, plain text, graphical image, HTML page, or PDF document. A graphical representation of BLOB data supports five image formats: BMP, Windows metafile, JPEG, GIF and PNG.

This exclusive feature represents numeric data from a table or a query result as a diagram with a possibility of customizing its appearance in various ways. You can also easy export the diagram to the following formats: BMP, Windows metafile, PDF, JPEG, PNG and more.

The Visual Query Builder is a powerful tool of PostgreSQL Maestro intended for designing queries as visual diagrams. This tool does not require any knowledge of the SELECT statement syntax, it will form a query automatically, you just need to mark what information do you want to retrieve.

In PostgreSQL Maestro you can customize the behavior of all its tools, select a user interface scheme and set a lot of other various preferences.

Additional Information