PostgreSQL Maestro is the premier Windows GUI admin tool for PostgreSQL server management, development and control. PostgreSQL Maestro allows you to create, edit, copy, extract and drop all the database objects such as schemas, tables, views, functions, domains, rules, sequences, languages, operators, etc., build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, manage PostgreSQL roles, users, groups and their privileges, and use a lot of other tools designed for the easiest and most efficient work with PostgreSQL Server.You are welcome to enjoy the abilities offered by a number of implemented tools providing excellent performance for all the necessary database operations.Easy database managementPostgreSQL Maestro allows you to create and drop databases quickly. Database profiles give you the opportunity to connect to databases in one touch and work with the selected databases only. Powerful database object management PostgreSQL Maestro provides you with an ability to manage database objects. For example, you can perform operations with a group of objects as well as with a single object in Object Manager, copy an object from one database to another by a drag-and-drop operation inside the explorer tree, use Windows clipboard to copy a set of objects and so on. Working with tables and table subobjectsPostgreSQL Maestro wizards and editors allow you to create, edit and drop tables as well as their fields, indexes, triggers and foreign keys in a couple of simple operations.Building and executing queriesPostgreSQL Maestro provides two powerful tools which allow you either to edit query text directly with syntax highlighting and code completion or to build a query diagram visually selecting tables and fields, setting links between tables and so on. Support of the latest PostgreSQL featuresUse PostgreSQL Maestro to work with any PostgreSQL server version from 7.3 to 8.1! Among other features and objects implemented in the latest versions of the server, our software supports parameter scopes, connection limits, tablespaces, changing column types, dollar-quotation and much more.Powerful data management tools With PostgreSQL Maestro you can view and edit table data (including BLOB fields), export and import data to/from MS Excel, MS Access, DBF, XML, TXT, CSV and other formats, get SQL data dump and more. Work with database metadata PostgreSQL Maestro provides you with a number of tools for working with database metadata and SQL scripts, including code folding. Security managementPostgreSQL Maestro provides you with an efficient way to manage access privileges. You can either grant/revoke permissions for a concrete database object such as table or function, or operate with user, roles , or group privileges. Easy PostgreSQL run-time configurationPostgreSQL Maestro helps you to assign a set of option settings either to a user or to a database in a few mouse clicks. Overriding of the default server settings becomes easy too.Full customization according to your preferences and needsIn PostgreSQL Maestro you can customize the behavior of all its tools, select a user interface scheme and set a lot of other preferences. Here are some key features of "PostgreSQL Maestro":