Navicat (PostgreSQL GUI) 8.2.15

Navicat (PostgreSQL GUI) 8.2.15 gives you a good and simple to use PostgreSQL database management tool, which can convert XML, CSV, MS Excel, MS Access, and popular data formats to PostgreSQL databases, eliminating time-consuming data entry and the errors that accompany it.

Other useful major features include import and export wizard, schedule backup, batch job scheduling, data synchronization, data transfer, visual query builder, and visual report builder. Furthermore, it supports PostgreSQL version 8.x (support stored procedure, triggers, and views).

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  
   • Support SSL secure connection  
   • 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  
   • Support to return multi-resultsets  
   • 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  
   • Transferring data to a SQL file with designated SQL format and encoding  
   • Data synchronization  
   • Structure synchronization  
7. Backup/Restore
   • Backing up/restoring database  
   • Restoring database with chosen database objects  
   • Converting backup file into SQL script    
   • Compressing/Decompressing Backup files  
   • 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  
   • Ability to attach Export Wizard/Report result files in Batch Job notification email  
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  
    • Ability to copy Connection Information into Clipboard

Enhancements:

• Bug Fixes:
• • "Class TSciMemo not found" error occured when opening PostgreSQL Aggregate Designer.
  • Data could not be updated/added in Table Viewer when using HTTP Tunnel connection to PostgreSQL server.
  • "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.

Requirements:

• Microsoft Windows 2000, XP, Vista, Server 2003, Server 2008, Windows 7
• 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