| Platforms |
Windows Enterprise
Edition
|
Windows Standard
Edition
|
Windows Lite
Edition
|
Mac OS X Standard
Edition
|
Mac OS X Lite
Edition
|
| PostgreSQL
Objects Management |
|
Support 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 |
|
|
|
|
|
