Features

  Full version Freeware version
Support of PostgreSQL, Amazon RDS for PostgreSQL, Amazon Redshift, Azure Database for PostgreSQL
Support of JSONB data type
Support of changing foreign key deferability parameters without recreating the key
Support of moving all objects from one tablespace to another
Changing column types
Support of argument names in functions
Support of dollar-quoted strings
Support of ENUM data types
Support of TSVECTOR, TSQUERY, XML and UUID types
Support of extensions
Support of arrays of composite types
Support of index key sorting order (ASC, DESC; NULLS FIRST, NULLS LAST)
Support of unlogged tables
Support of materialized views
Support of event triggers
Support of partitioned tables
New state-of-the-art graphical user interface
Dark visual schema support
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
up to 5
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, procedures, collations, 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 designer allowing you to build complicated queries without any knowledge of SQL syntax
Query data editor with code completion, syntax highlight and code folding
Large script execution (in Execute script editor)
Ability to view query plan as diagram
SQL Formatter available (from Execute script editor)
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
Database change management
Support of Concurrent Versions System (CVS), Subversion (SVN), Visual SourceSafe (VSS), Team Foundation Server (TFS)
Ability to manage database-related development processes
Ability to roll back a database structure to any previous version
Ability to create database branches
Ability to create tags/labels to save the current database state
Ability to get a script of differences between two database states and test it on a created test database
Ability to store any SQL scripts in the Version Control System repository of the database
Ability to browse history of database and/or object changes
Easy-to-use wizards performing PostgreSQL maintenance tasks
Analyzing tables
Vacuuming tables
Clustering tables
Reindexing tables
Server Log Viewer
Backup Database wizard
Restore Database wizard
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
Database Extensions
SQL Monitor
Compare Database wizard
Search in metadata tool
And other useful features
Keyboard templates
To-do list
External tool manager