Navicat for PostgreSQL 8.2.8

Navicat is a powerful PostgreSQL database administration and development tool that is not only sophisticated enough for professional developers, but also easy to learn for new users.
With an user-friendly GUI, Navicat lets you quickly and easily create, organize, access and share information in a secure and convenient way.

Navicat supports multiple PostgreSQL server connections which can be connected locally or remotely. Your remote PostgreSQL server can be running on Mac OS X, Linux, Unix, or Windows platform.

Major Features:

1. Latest PostgreSQL Versions Support: Navicat PostgreSQL a powerful PostgreSQL Database Server administration and development tool. Highlights of supported features:
   • Supports PostgreSQL Servers 7.3 or above
   • Support of Multiple Connections to local or remote PostgreSQL Server
   • Support of Unicode / Character Set
   • Support of PostgreSQL Views and Functions creation
   • Support all PostgreSQL subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers.
2. Additional Connection Options
   • Support of SSH Tunnel: Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts. The authentication method can use a password or public / private key pair.
   • Support of HTTP Tunnel: Navicat comes with HTTP Tunneling while your ISPs do not allow direct connections to their PostgreSQL server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a PostgreSQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does.
   • Export Registry Record(.reg) via Navicat PostgreSQL: You can easily transfer your connection settings while migrating Navicat from one computer to another new machine. Simply export a registry file via Navicat and restore it on the new machine.
3. Instant Navigation Over Database
   • Show databases as an open state once connection starts: Have your preferable databases opened right after the connection is made. Save your time and work more efficiently!
4. Comprehensive Management of PostgreSQL objects
   • Create, edit and drop table's fields, indexes, foreign keys, uniques, checks, rules, triggers and privileges: With Table Designer the basic Navicat PostgreSQL tool for working with tables, you can create, edit and drop table's fields, indexes, foreign keys, checks, rules, triggers, privileges and much more.
   • Dump object definition as sql file: Backup object definition and data with ease by dumping as sql file.
   • Print Database / Table Structure: Present the database / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.
5. Diversified Import and Export Competence
   • Import data from ODBC: You can import data from ODBC after setting up a data source connection. All available tables will be included if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.
   • Import data from up to 18 most popular formats including MS Access, MS Excel, XML, PDF and TXT: Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.
   • Export data to MS Access, MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc: Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.
   • Export data and create records as INSERT statements in sql file: During Data Transfer, you can choose to export data as sql file with record options like complete insert statements etc.
6. Powerful Data Manipulation Tools
   • Form View: Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.
   • Support of Foreign Key Data Selection: With the GUI tool Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!
   • Data and Structure Synchronization: Navicat for PostgreSQL allows you to transfer data from one PostgreSQL database to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target database can be on the same server as the source database or on another PostgreSQL server.
   • Support of Data Transfer between local / remote PostgreSQL databases: Transfer tables / views / functions from one PostgreSQL database to another PostgreSQL database, or to a plain text file.
   • Support of Backup and Restore PostgreSQL databases: Regular backup on database is important to users. Backup / restore all tables and records, views and functions for your PostgreSQL database using Navicat. You can also schedule backups between databases.
   • Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization: Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Report printing, Backup, Data Transfer, Data Synchronization, Import and Export.
   • Send notification e-mail for schedule task: Generate notification e-mails to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule.
7. Powerful Security Management
   • Visual User Manager: Navicat provides users a visual tool for user management. You can easily add, duplicate, delete users, and edit global user privileges, and grant privileges on the selected databases, schemas, tables / views and tablespaces / functions.
8. Well-Designed Visual Builder / Editor
   • Visual Query / View Builder: Visual Query / View Builder which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.
   • Query Editor: It allows you to create and edit SQL text for a query, prepare and execute selected queries.
   • Support of Parameter Query: Set query parameters to add variable values to a query each time you run it.
   • Code-Completion for Query and View: Experience a quick way in constructing SQL statements in Query Editor and View with the Code-completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.
9. Easy-to-use Report Builder *only available in Windows Enterprise Version
   • Create reports with visual Report Builder: Create different types of reports with user-friendly GUI Report Builder. Design reports for Invoice, Statistics, Mailing Labels and more.
   • Export report to multiple formats, PDF, Excel, HTML etc.: Enjoy more output formats for report export text, pdf, Lotus, Excel, Graphic, Html and more. Check out the feature in Report Builder included in Navicat Enterprise Version.
   • View and share reports with others by using Report Viewer: Navicat Report Viewer allows you to navigate reports designed by Navicat PostgreSQL's Report Builder. The coolest thing about it is that you can share reports with someone who does not have Navicat running on his computer but has Navicat Report Viewer installed.
   • Report Archive: Navicat allows you to save reports as an archive file (.raf) for backup and increased portability.
10. More great features
    • Virtual Grouping: Have a better organization over connections in Navicat. You can categorize them into groups with the Virtual Grouping feature.
    • Server Monitor: Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status Tab to show and / or modify the properties of PostgreSQL servers.
    • SQL Console: To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.
    • Docking: You can customize your window behaviour style into Docking Windows or Floating Windows. Choose either dock the opened windows to the main window or dock windows or inherit the last docking style.
    • Profile System: For most of the tasks, Navicat allows you to save / load profiles to increase convenience. Profile can be applied on Data Transfer, Data / Structure Synchronization, Batch Job, Backup, Import / Export etc.
    • Text / Blob View: Navicat provides Text / Blob Viewer and Editor to view and edit TEXT / BLOB fields content. The editor allows you to view, update, insert or delete data in a table.

Enhancements:

• Code Completion - Speedup your sql writing.
• Form View - Input record via form view.
• New Profile System - Open profile on your desktop directly.
• Report Export - Export report to pdf, html and more.
• Compatible with any PostgreSQL server version up to 8.2.x.
• Incremental Search, Hex Editor and more supports in Table View.
• Usability enhancement in Table Design.
• Many other improvements on features and user-friendliness.

Requirements:

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