Navicat for PostgreSQL 8.2.5

Navicat for PostgreSQL 8.2.5 is a very popular PostgreSQL tool for administration and development. This all-inclusive PostgreSQL front end provides a powerful graphical interface for databases management, development and maintenance. Easy installation and intuitive interface make it an irreplaceable tool for PostgreSQL on the Web or your local desktop. Navicat let you converts Access to PostgreSQL, MS SQL to PostgreSQL, Excel to PostgreSQL, synchronizes and backups database in a snap through helpful wizards. Major features include Visual Query Builder, Import/ Export, Report Builder, Backup/ Restore, SSH Tunneling and Data Transfer. Navicat also supports to import data from ODBC, batch job scheduling (create schedule for Import/Export, Data Transfer and saved queries), printing of table structure.

Navicat for PostgreSQL is a powerful Database administration and development tool for PostgreSQL. It works with any PostgreSQL Database Server from version 8.0 or above, and supports most of the latest PostgreSQL features including Trigger, Function, View, and Manage User, etc. Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to PostgreSQL.

Major Features:

1. With Navicat well-designed Graphical User Interface (GUI), Navicat for PostgreSQL lets you quickly and easily create, organize, access and share information in a secure and easy way, taking PostgreSQL administration to the next level.
2. Navicat for PostgreSQL is available for two platforms – Microsoft Windows and Mac OS X. It connects users to any local/remote PostgreSQL Server, providing several database utilities such as Data/Structure Synchronization, Import/Export, Backup and Report, to facilitate the process of maintaining data.
   • 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.
3. 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.
4. 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.
5. 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.
6. 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!
7. 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.
8. Dump object definition as sql file
   • Backup object definition and data with ease by dumping as sql file.
9. Print Database / Table Structure
   • Present the database / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.
10. 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.
11. 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.
12. 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.
13. 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.
14. 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.
15. 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.
16. Server Monitor
    • SSelect 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.
17. 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.

Requirements:

• 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.