Navicat for PostgreSQL 8.2.11

Major Features:

1. PostgreSQL Objects Management
   • Supports PostgreSQL Servers 7.3 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
2. 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
3. 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
4. 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
   • Ability to preview SQL before execution
   • SQL console
5. 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
6. Other Data Manipulation Tools
   • Data transfer
   • Transfering data to SQL script as INSERT statement
   • Data synchronization
   • Structure synchronization
7. 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 
8. 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 
9. 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 
10. Report Management Tools
    • Report Builder 
    • Report Viewer 
11. 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

Enhancements:

• Support of UUID for PostgreSQL server 8.3 or above.
• Fix:
  
• • "SSH Tunnel:''is not a valid integer value" error occured during SSH connection.
  • When exported data to MS Access, month and day values were mixed up.
  • Slow problem while transfering data from command line.
  • "permission denied for relation pg_authid" error occured when creating table for ProgreSQL server.
  • Access Violation error happened when creating new table with index.
  • Index, constraint and trigger could not be renamed in Table Designer.

• Microsoft Windows 2000, XP, Vista or 2003
• Pentium II processor or above
• 64 megabytes (MB) of RAM
• Hard-disk space vary depending on installation. Full installation requires 10 MB of available hard-disk space