• Print this Page

Full support of PostgreSQL up to version 8.3

• Support of FILLFACTOR parameter for tables and indices
• Creating indexes concurrently
• Creating domains based on other domains
• Support of CONNECT permission for databases and USAGE permission for sequences
• Changing column types
• Support of argument names in functions
• Support of dollar-quoted strings
• Support of UTF8 data
• Support of ENUM data types
• Support of TSVECTOR, TSQUERY, XML and UUID types
• Support of arrays of composite types
• Support of index key sorting order (ASC, DESC; NULLS FIRST, NULLS LAST)

New state-of-the-art graphical user interface

• Office 11 and Windows XP visual schemes support
• New well-described Wizard System
• Improved database explorer for easy management of all PostgreSQL objects
• New Windows Toolbar to switch between windows easily, like in Windows Task Bar
• Navigation bars with hot actions in most of the windows
• Ability to save all program settings
• Customizable toolbars for all program windows
• Fully customizable program interface
• Powerful visual options module
• Localizable program interface

Rapid database management and navigation

• Multiple host/database connections
• SSL connections support
• Registering selected databases to work with
• Projects to work with the selected database objects only
• Access to PostgreSQL Server through HTTP protocol
• Connecting via local port forwarding through the SSH tunnel
• Multiple user-defined tabs for any tree node to access it in one-click
• Working with multiple selected objects at a time
• Grouping/Ungrouping registered databases by host name

Easy management of all PostgreSQL objects

• Creating/dropping databases and schemas
• Managing tables and all their subobjects: fields, indices, triggers, rules, checks and foreign keys
• Managing views, functions, sequences
• Managing types, aggregates, operators, languages
• Managing table/view rules
• Duplicating all database objects
• Renaming all database objects
• Powerful PL/pgSQL function debugger
• Viewing dependencies between database objects

Advanced data manipulation tools

• Powerful BLOB viewer/editor with several types of viewing BLOB data
• Plenty of useful tools such as data grouping, fast searching and filtering
• Master-detail view to work with two linked tables at the same time
• Table and card views to see data the way you like
• Ability to copy and paste selected records
• Ability to create diagrams based on queries
• Exporting data to SQL script as INSERT statement

Effective security management

• Powerful user and group manager for administering users and privileges
• Grant manager displaying all database object grants in the form of a grid
• Viewing and changing object permissions to database roles in object editors

Excellent visual and text tools for query building

• Visual query builder allowing you to build complicated queries without any knowledge of SQL syntax
• Multiple SQL editors with code completion, syntax highlight and code folding
• Large script execution (SQL script editor)
• Ability to view query plan as diagram
• SQL Formatter (Available from SQL Editor context menu)
• Favorite Queries (Save and use your frequently used queries easily)

Report designer with clear in use report construction wizard

• New Create Report Wizard allows you to create simple reports in a few clicks
• Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree

Impressive data export and import capabilities

• Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF etc
• Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV
• Wizards for copying data from/to file on server
• Copying metadata and data from one database to another as a whole or partially

Powerful visual database designer

• Two diagram notations (IDEF1x and IE)
• Useful diagram navigation tool
• Reverse engineering
• Several pages in one diagram to divide diagram into different subject areas
• Ability to create, edit and drop tables and table fields, set links between tables visually
• Ability to add comments to diagram
• Saving as image or printing database diagram
• A lot of visual customization options

Easy-to-use wizards performing PostgreSQL maintenance tasks

• Analyzing tables
• Vacuuming tables
• Clustering tables
• Reindexing tables
• Server Log Viewer

Other useful tools to make your work with PostgreSQL Server as easy as it can be

• Database statistics module to view various statistic information on database objects
• Extracting metadata into text files or SQL script editor
• Powerful print metadata module for creating customizable metadata reports
• HTML report wizard to create a detailed HTML report about your database quickly
• Report designer for building powerful reports visually
• Wizard to download and upload files from/to PostgreSQL server
• SQL Monitor

And other useful features

• Keyboard templates
• To-do list
• External tool manager