| Version Professional | Version Lite | |||
|---|---|---|---|---|
| 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 | + | + | ||
