제품들 PostgreSQL용 Navicat Mac OS X 용

For Mac OS X


Latest PostgreSQL Versions Support
Additional Connection Options
Comprehensive Management of PostgreSQL objects
Diversified Import and Export Competence
Powerful Data Manipulation Tools
Powerful Security Management
Well-Designed Visual Builder / Editor
More great features

Product Brochure
System Requirements
  • Mac OS X 10.4 Tiger or 10.5 Leopard

Latest PostgreSQL Versions Support

Navicat PostgreSQL - a powerful PostgreSQL Database Server administration and development tool. Highlights of supported features:
- Support of PostgreSQL versions from 8.0 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 of Triggers
- Support of Foreign Keys

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

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.

View Database / Table Structure
Present the database / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.


Diversified Import and Export Competence

Import data up to 5 most popular formats including XLS, CSV, TXT, DBF and XML

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 different file formats: TXT, CSV, DBF and XML
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.


Powerful Data Manipulation Tools

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, Backup, Data Transfer, Data Synchronization, Import and Export.

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.

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.


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

Tabbed Windows
Customize your window behaviour style. Navicat supports you of dragging windows in and out of the tabbed windows.

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.