Navicat for PostgreSQL

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 and Google Cloud and all PostgreSQL database objects.

Navicat comes with numerous improvements and features to address your database development needs. With over 100 enhancements and a brand new interface Navicat gives you new ways to build, manage and maintain your databases.

Key Features:

• Seamless Data Migration: Data Transfer, Data Synchronisation and Structure Synchronisation help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across various DBMS. Compare and synchronise databases with Data and Structure Synchronisation. 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 customisable Code Snippet by getting suggestions for keywords and stripping the repetition from coding. Quickly locate and correct PL/SQL and 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.
  
• Increase your Productivity: Our powerful local backup/restore solution and intuitive GUI for Oracle Data Pump/SQL Server Backup Utility guides you through the backup process and reduces the potential for errors. Compile professional high-quality reports in minutes using an interactive design interface and efficient workflow and set an automation for repeatable deployment process like report generation, database backup and script execution at a specific time or day. No matter where you are, you can always get the job done.
  
• Make Collaboration Easy: Synchronise 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 maximise 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 and GSSAPI authentication for PostgreSQL. Navicat 12 provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.

Navicat for PostgreSQL - Features

Navicat is a PostgreSQL database administration and development tool. With an user-friendly GUI, Navicat lets users quickly and easily create, organise, 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 Linux, Unix, Mac OS X or Windows platform.

Windows Edition

Main Featured Functions:

• Data and Structure Synchronization
• Query Builder - create query from different databases
• Query Parameter
• SQL Console
• View Builder
• Private Key for SSH Tunnel
• SSH Tunnel
• Stored Procedure
• Foreign Keys
• Edit text in Blob field
• Print Table Structure
• Import data from ODBC
• Import / Export data up to 18 most popular formats including MS Access, MS Excel, XML, PDF and TXT.
• Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization.
• Create Reports with visual Report Builder
• Report Archive - Reports can be saved as an archive file (.raf) for backup and increased portability.
• Create Report Archive from command line.

Mac Edition

Main Featured Functions:

• SSH Tunnel
• Data and Structure Synchronization
• SQL Console
• Views
• Support Multiple Connections for local or remote PostgreSQL servers
• Create and delete Databases, Tables, Indexes and Users
• Stored Procedure
• Foreign Keys
• Unicode and Character Set Support
• Import / Export data up to 4 most popular formats including CSV, TXT, DBF and XML
• Create / Run SQL queries
• Print Table Structure
• Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization.
• Data Transfer - Support transfer databases from one PostgreSQL server to another PostgreSQL server
• Backup / Restore your database
• Manage user privileges [Security Configuration]

Feature comparison

Navicat for PostgreSQL - System Requirements

• Microsoft Windows 95/98, ME, NT, 2000, XP 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.