| Platforms |
Windows Enterprise
Edition
|
Windows Standard
Edition
|
Windows Lite
Edition
|
Mac OS X Standard
Edition
|
Mac OS X Lite
Edition
|
|
PostgreSQL Objects
Management
|
| Supports PostgreSQL
Servers 8.0 or above |
+
|
+
|
+
|
+
|
+
|
| Create /drop
databases and schemas |
+
|
+
|
+
|
+
|
+
|
| Support all PostgreSQL
objects: tables, views and functions |
+
|
+
|
+
|
+
|
+
|
| Support all subobjects:
fields, indices, foreign keys, uniques, checks, rules
and triggers |
+
|
+
|
+
|
+
|
+
|
| Managing tablespace |
+
|
+
|
+
|
+
|
+
|
| Managing cast
and languages |
+
|
+
|
+
|
+
|
+
|
| Managing aggregates,
conversions, domains, trigger functions, operators and
classes, sequences and types |
+
|
+
|
+
|
+
|
+
|
| Support of character
set and unicode |
+
|
+
|
+
|
+
|
+
|
| Connection
Management and Navigation |
| Multiple local/remote
PostgreSQL server connections |
+
|
+
|
+
|
+
|
+
|
| Connection to
PostgreSQL Server through SSH |
+
|
+
|
+
|
+
|
+
|
| Connection to
PostgreSQL Server through HTTP |
+
|
+
|
+
|
+
|
+
|
| Backup connection
informations |
+
|
+
|
+
|
-
|
-
|
| Customize selected
databases to work with |
+
|
+
|
+
|
+
|
+
|
|
Data Viewer
and Editor
|
| Grid view |
+
|
+
|
+
|
+
|
+
|
| Form view |
+
|
+
|
-
|
-
|
-
|
| Text, Hex and
BLOB viewer/editor |
+
|
+
|
+
|
+
|
+
|
| Copying and pasting
selected records |
+
|
+
|
+
|
+
|
+
|
| Customize display
formats |
+
|
+
|
+
|
-
|
-
|
| Incremental search,
sorting and formatting table grid |
+
|
+
|
+
|
+
|
+
|
| Support of raw
mode edit: apply PostgreSQL built-in function |
+
|
+
|
+
|
+
|
+
|
| Support of foreign
key data selection: locate the available values from the
reference table |
+
|
+
|
-
|
+
|
-
|
| Filtering Records |
+
|
+
|
-
|
+
|
-
|
| Ability to set
number of records showing on each page |
+
|
+
|
+
|
+
|
+
|
|
SQL Processing
|
| Visual query/view
builder to facilitate the process of building complicated
queries |
+
|
+
|
-
|
+
|
-
|
| Ability to create
parameter queries |
+
|
+
|
+
|
+
|
+
|
| Multiple SQL editors with syntax
highlighted feature |
+
|
+
|
+
|
+
|
+
|
| Code completion
for SQL editors |
+
|
+
|
-
|
-
|
-
|
| SQL console |
+
|
+
|
+
|
+
|
+
|
|
Diversified
Import and Export Competence
|
| Importing data
from ODBC: MSSQL, Oracle etc |
+
|
+
|
-
|
-
|
-
|
| Importing data
from MS Excel |
+
|
+
|
-
|
+
|
-
|
| Importing data
from MS Access |
+
|
+
|
-
|
-
|
-
|
| Importing data
from other file formats : TXT, CSV, XML, DBF etc |
+
|
+
|
-
|
+
|
-
|
| Exporting data
to MS Excel |
+
|
+
|
-
|
-
|
-
|
| Exporting data
to MS Access |
+
|
+
|
-
|
-
|
-
|
| Exporting data
to HTML and PDF |
+
|
+
|
-
|
-
|
-
|
| Exporting data
to most popular formats: TXT, CSV, XML, DBF etc |
+
|
+
|
-
|
+
|
-
|
|
Other Data Manipulation
Tools
|
| Data transfer |
+
|
+
|
-
|
+
|
-
|
| Transfering data
to SQL script as INSERT statement |
+
|
+
|
-
|
+
|
-
|
| Data synchronization |
+
|
+
|
-
|
+
|
-
|
| Structure synchronization |
+
|
+
|
-
|
+
|
-
|
| Backup/Restore |
| Backing up/restoring
database |
+
|
+
|
-
|
+
|
-
|
| Restoring database
with chosen database objects |
+
|
+
|
-
|
-
|
-
|
| Converting backup
file into SQL script |
+
|
+
|
-
|
+
|
-
|
| Backing up database/table
to SQL script |
+
|
+
|
+
|
+
|
+
|
| Executing SQL
script |
+
|
+
|
+
|
+
|
+
|
| Schedule
for Batch Job |
| Ability to set
schedule on backup, query execution, import/export, data
transfer and data synchronization |
+
|
+
|
-
|
+
|
-
|
| Schedule report
printing |
+
|
-
|
-
|
-
|
-
|
| Schedule to print
report to files: PDF, Excel, HTML etc |
+
|
-
|
-
|
-
|
-
|
| Sending notification
e-mail for schedule task |
+
|
+
|
-
|
-
|
-
|
| Server
Security and Maintenance Services |
| Visual user manager
to administer users, groups (roles) and privileges |
+
|
+
|
+
|
+
|
+
|
| Analyzing, vacuuming
and reindexing tables |
+
|
+
|
+
|
+
|
+
|
| Server Monitor
to view system variables and server status information |
+
|
+
|
-
|
+
|
-
|
| Report
Management Tools |
| Report Builder |
+
|
-
|
-
|
-
|
-
|
| Report Viewer |
+
|
-
|
-
|
-
|
-
|
| Other
Useful Features |
| Duplicate/empty/
truncate tables |
+
|
+
|
+
|
+
|
+
|
| Create table/view
shortcut on desktop |
+
|
+
|
+
|
-
|
-
|
| Print database/schema/table
Structure |
+
|
+
|
-
|
+
|
-
|
| Support of docking/tab
windows |
+
|
+
|
+
|
+
|
+
|
| Support of virtual
grouping: provide logical organization over connections |
+
|
+
|
-
|
+
|
-
|
| Ability to run
profile from command line |
+
|
+
|
+
|
+
|
+
|
| Log files: keep
track on the actions have been performed in Navicat |
+
|
+
|
+
|
+
|
+
|
home
previous
