|
| 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 | | |
|
| 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 | | |
|
| 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 | | |
|
| 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 | | |
|
| 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 | | – |
|
| 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 | | |
|
| 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) | | |
|
| 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 | | – |
|
| 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 | | – |
|
| 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 | | – |
|
| 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 | | – |
|
| Analyzing tables | | – |
| Vacuuming tables | | – |
| Clustering tables | | – |
| Reindexing tables | | – |
| Server Log Viewer | | – |
| Backup Database wizard | | |
| Restore Database wizard | | |
|
| 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 | | – |
|
| Keyboard templates | | |
| To-do list | | |
| External tool manager | | |
