Online Documentation for SQL Manager for PostgreSQL

Feature Matrix


The FREE Lite version of SQL Manager for PostgreSQL does not include all features of the Full version and has some limitations concerning the number of the databases that can be registered and the set of data manipulation and server maintenance tools. The detailed feature matrix is given below.

 

Note that when using the FREE Lite version of SQL Manager for PostgreSQL you can activate a 30-day period of fully-functional usage. After the period expires, you will be able to continue using the Lite version.

 

For more information on activating the Full version features see Full Mode activation.

Full version Lite version
Full support of PostgreSQL up to the latest versions
Support of exclusion constrains + +
Support of the ‘when’ clause for triggers + +
Support of default values for function arguments + +
Support of functions returning table + +
Support of collations + +
Support of extensions + +
Support of view triggers + +
Support of unlogged tables + +
Support of materialized views + +
Support of recursive views + +
Support of event triggers + +
Support of UTF8 data + +
New state-of-the-art graphical user interface
Dark visual schema support + +
New well-described Wizard System + +
Improved database explorer for easy managing 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 + +
Flexible visual options + +
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, procedures, sequences, collations + +
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 modes 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 + -
Multiple SQL editors with code completion, syntax highlight and code folding + +
Large script execution (Execute cript editor) + +
Ability to view query plan as a diagram + -
SQL Formatter (available from Query data editor) + -
Favorite Queries (Save and use your frequently used queries easily) + +
Report designer with a clear in use report construction wizard
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 the 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 database structure to any version in the past + -
Ability to create database branches + -
Ability to create tag/label 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 version control system repository of a 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 + -
Compare Databases wizard + -
Database Extensions + +
SQL Monitor + +
Search in metadata tool + -
...and other useful features
Keyboard templates + +
To-do list + +
External tool manager + +