商品明細

Navicat for PostgreSQL 資料庫管理開發

商品簡述

Navicat for PostgreSQL是一套資料庫開發工具,你可以快速輕鬆地建立、管理和維護資料庫

商品介紹

本產品出貨為最新版本。
如需購買或了解內容請來電(2749-1909)或來信(
sales@ahasoft.com.tw)業務部
___________________________________________________________________

Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database development. From writing simple SQL queries to developing complex databases, Navicat for PostgreSQL is designed to accommodate a wide range of users, from PostgreSQL beginners to seasoned developers. Connect to local/remote PostgreSQL servers and compatible with cloud databases like Amazon Redshift, Amazon Aurora, Amazon RDS, Google Cloud and Microsoft Azure, and all PostgreSQL database objects.

Features


Seamless Data Migration
Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across databases. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.


Diversified Manipulation Tool
Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables, views, or query results to formats like Excel, Access, CSV and more. Add, modify, and delete records with our spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.


Easy SQL Editing
Visual SQL Builder will help you create, edit and run SQL statements without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding. Quickly locate and correct PL/PGSQL coding errors using our debugging component such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack.


Intelligent Database Designer
Create, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.


Data Visualization Tool
Our Charts feature lets you create visual representations of large data sets and help you to gain deeper insights from your data. Explore and unearth patterns, trends and relations between data, and create effective visual outputs to present your findings in dashboard for sharing.


Increase Your Productivity
Our powerful local backup/restore solution and intuitive GUI for MongoDump, Oracle Data Pump and SQL Server Backup Utility guides you through the backup process and reduces the potential for errors. Set an automation for repeatable deployment process like database backup, MapReduce job and script execution at a specific time or day. No matter where you are, you can always get the job done.


Make Collaboration Easy
Synchronize your connection settings, models, queries and virtual groups to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. 


Advanced Secure Connection
Establish secure connections through SSH Tunneling and SSL ensure every connection is secure, stable, and reliable. Support different authentication methods of database servers such as PAM authentication for MySQL and MariaDB, Kerberos and X.509 authentication for MongoDB, and GSSAPI authentication for PostgreSQL. Navicat provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.


Cross-Platform Licensing

Cross-platform licensing is now available. Whether you’re operating on Windows, macOS, or Linux, you can purchase once and select a platform to activate and later on transfer your license.


Dark Mode
Set dark theme to protect your eyes from the traditionally blinding whiteness of computer. No behavior changes with how pages look when you are in dark mode.

Feature Matrix

Essentials  

Standard  

Enterprise

Connection

PostgreSQL 7.3 or later

Amazon Redshift, Amazon Aurora, Amazon RDS, Google Cloud, Microsoft Azure, Alibaba Cloud, Tencent Cloud, Huawei Cloud

Secure connection: SSH/HTTP/SSL

GSSAPI authentication

Export/import connection settings

Navicat Cloud

Collaboration: create projects, add members

Synchronize connections and queries

Synchronize models

Synchronize virtual groups

Data Viewer and Editor

Grid view

Form view

Foreign key data selection

Text, Hex, Image or Web viewer/editor

Raw mode editing

Find and replace

Filter records

SQL Processing

PL/PGSQL Debugger

SQL Editor

Visual SQL Builder

Code Snippet and Completion

SQL Code Beautifier/Minifier

Find and replace

Create parameter queries

Open query files in an external editor

Console

Data Visualization

Support 20 chart types

Visualize live data

Customize multiple pages dashboard

Add interactive controls

Data Modeling

Physical model

Reverse/forward engineering

Auto layout

Add vertices, layers, images, notes, labels and shapes

Print database diagrams to PDF and graphic files

Import/Export

Import/export data from/to plain text file formats: TXT, CSV, XML, JSON

Import/export data from/to most popular formats: DBF etc

Import data from ODBC, MS Excel, MS Access

Export data to MS Excel, HTML

Export data to MS Access (Windows Edition only)

Data Manipulation

Data Transfer

Data/Structure Synchronization

Backup/Restore

Backup/restore database

Convert backup file into SQL script

Dump/Execute SQL file

Automation

Set schedule on backup, query execution, import/export, data transfer and data synchronization

Run profiles from different servers in a single batch job

Include attachment for export file in notification email

Server Security

Manage user

Server Monitor

Other Useful Features

ER Diagram view

Virtual grouping

Customize connection colorings

Database wide search

Favorites list

Print database/schema/table structure

Dark mode

System Requirements

Windows

Microsoft Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10, Server 2008, Server 2012, Server 2016, Server 2019

macOS

MacOS 10.12 Sierra or later

Linux

Debian 9 or later, Ubuntu 16.04 or later, CentOS 7 or later, Fedora 26 or later, Linux Mint 18 or later

Windows
Main Screen


Object Designer


macOS
Main Screen


Object Designer


Linux
Main Screen


Object Designer