Navicat Essentials For PostgreSQL
Navicat Essentials for PostgreSQL (Linux) is a compact version of Navicat which provides basic and necessary features you will need to perform simple administration on a database. Navicat Premium Essentials is an advanced utility that lets you administer SQL databases with user-friendly options and configuration settings. It offers support for MySQL, PostgreSQL, Oracle. Navicat Essentials is for Commercial use. Currently, Navicat Essentials is available for MySQL, SQL Server, PostgreSQL, Oracle and SQLite databases. If you need to administer all the above database. Enterprise Essentials: MariaDB 5.1 or later: Enterprise Essentials: MongoDB 3.0 or later: Enterprise Essentials: Oracle 8.1 or later ( macOS Edition starts from Oracle 9i ) Enterprise Essentials: PostgreSQL 7.3 or later: Enterprise Essentials: SQLite 2 and 3: Enterprise Essentials: SQL Server 2000 or later: Enterprise Essentials.
Navicat Essentials is a compact version of Navicat which provides the basic and necessary features you will need to perform simple database development. Navicat Essentials is for commercial use and is available for MySQL, MariaDB, MongoDB, SQL Server, PostgreSQL, Oracle, and SQLite databases. If you need to administer all aforementioned database servers at the same time, there is also Navicat Premium Essentials which allows you to access multiple servers from a single application.
Main Screen
Intuitive and well-designed GUI simplifies your database administration and development.
Object Designer
Manage all the database objects with smart object designer.
Data Manipulation for RDBMS
Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.
Data Manipulation for MongoDB
Insert, edit, or delete data using our various data editors.
Import/Export
Import/export data from/to plain text file formats.
Navicat Cloud
Store your files in cloud to start collaboration with your team members.
Features
The All-New Engine
We focus strongly on improving responsiveness, usability, and performance. We engineered an entirely new mechanism and applied multithreading, so you can run certain tasks in parallel to increase the overall efficiency of your database development.
Cloud Database Navigation
Manage both on-premises and cloud databases such as Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud and MongoDB Atlas. Just simply establish connection using the pertinent information that your cloud databases provide.
Effortless Deployment Toolkit
Add your favorite tabs to On Startup and have them open automatically when Navicat launches, and use MacBook Pro Touch Bar to easily access Navicat features and controls.
Diversified Manipulation Tool
Use Import/Export Wizard to have data conversion from plain text formats such as TXT, CSV, XML and JSON. Add, modify, and delete records with our built-in editors, you can facilitate your edits in Tree View, JSON View, and the classic spreadsheet-like Grid View. Navicat Essentials gives you the tools you need to manage your data efficiently and ensure a smooth process.
Make Collaboration Easy
Synchronize your connection settings and queries 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. Learn more >
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.
Main Screen
Intuitive and well-designed GUI simplifies your database administration and development.
Object Designer
Manage all the database objects with smart object designer.
Data Manipulation for RDBMS
Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.
Data Manipulation for MongoDB
Insert, edit, or delete data using our various data editors.
Import/Export
Import/export data from/to plain text file formats.
Navicat Cloud
Store your files in cloud to start collaboration with your team members.
Features
The All-New EngineWe focus strongly on improving responsiveness, usability, and performance. We engineered an entirely new mechanism and applied multithreading, so you can run certain tasks in parallel to increase the overall efficiency of your database development.
Cloud Database NavigationManage both on-premises and cloud databases such as Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud and MongoDB Atlas. Just simply establish connection using the pertinent information that your cloud databases provide.
Effortless Deployment ToolkitAdd your favorite tabs to On Startup and have them open automatically when Navicat launches, and use MacBook Pro Touch Bar to easily access Navicat features and controls.
Diversified Manipulation ToolUse Import/Export Wizard to have data conversion from plain text formats such as TXT, CSV, XML and JSON. Add, modify, and delete records with our built-in editors, you can facilitate your edits in Tree View, JSON View, and the classic spreadsheet-like Grid View. Navicat Essentials gives you the tools you need to manage your data efficiently and ensure a smooth process.
Make Collaboration EasySynchronize your connection settings and queries 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. Learn more >
Advanced Secure ConnectionEstablish 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 LicensingCross-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.
Main Screen
Intuitive and well-designed GUI simplifies your database administration and development.
Object Designer
Manage all the database objects with smart object designer.
Navicat Essentials For Postgresql Tutorial
Data Manipulation for RDBMS
Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.
Data Manipulation for MongoDB
Insert, edit, or delete data using our various data editors.
Import/Export
Import/export data from/to plain text file formats.
Navicat Cloud
Store your files in cloud to start collaboration with your team members.
Features
The All-New Engine
We focus strongly on improving responsiveness, usability, and performance. We engineered an entirely new mechanism and applied multithreading, so you can run certain tasks in parallel to increase the overall efficiency of your database development.
Cloud Database Navigation
Manage both on-premises and cloud databases such as Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud and MongoDB Atlas. Just simply establish connection using the pertinent information that your cloud databases provide.
Effortless Deployment Toolkit
Add your favorite tabs to On Startup and have them open automatically when Navicat launches, and use MacBook Pro Touch Bar to easily access Navicat features and controls.
Diversified Manipulation Tool
Use Import/Export Wizard to have data conversion from plain text formats such as TXT, CSV, XML and JSON. Add, modify, and delete records with our built-in editors, you can facilitate your edits in Tree View, JSON View, and the classic spreadsheet-like Grid View. Navicat Essentials gives you the tools you need to manage your data efficiently and ensure a smooth process.
Make Collaboration Easy
Synchronize your connection settings and queries 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. Learn more >
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 LicensingCross-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.
System Requirements | ||
Windows Microsoft Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10, Server 2008, Server 2012, Server 2016, Server 2019 | macOS Mac OS X 10.11 El Capitan, macOS 10.12 Sierra, macOS 10.13 High Sierra, macOS 10.14 Mojave, macOS 10.15 Catalina | Linux Debian 9 or later, Ubuntu 16.04 or later, CentOS 7 or later, Fedora 26 or later, Linux Mint 18 or later |
| Essentials | Enterprise |
| General | |
| MySQL 3.21 or later, Drizzle, OurDelta, and Percona Server | |
| MariaDB 5.1 or later | |
| MongoDB 3.0 or later | |
| Oracle 8.1 or later ( macOS Edition starts from Oracle 9i ) | |
| PostgreSQL 7.3 or later | |
| SQLite 2 and 3 | |
| SQL Server 2000 or later | |
| Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud, Alibaba Cloud, Tencent Cloud, MongoDB Atlas, Huawei Cloud | |
| Connection | |
| Secure connection: SSH/HTTP/SSL | |
| PAM and GSSAPI authentication | |
| Kerberos and LDAP authentication | |
| x.509 certificate authentication | |
| Export/import connection settings | |
| Navicat Cloud | |
| Collaboration: create projects, add members | |
| Synchronize connections and queries | |
| Synchronize models and virtual groups | |
| Data Viewer and Editor | |
| Grid view, Tree view and JSON view | |
| Form view | |
| Foreign key data selection | |
| Text, Hex, Image, Web or BFile viewer/editor | |
| Raw mode editing | |
| Data Validation | |
| Customize data type colorings | |
| Find and replace | |
| Filter records | |
| SQL/Script Processing | |
| PL/SQL and PL/PGSQL Debugger | |
| SQL/Script Editor | |
| Visual SQL/Script Builder | |
| Find Builder | |
| Aggregate Builder | |
| Code Snippet and Completion | |
| SQL/Script Beautifier and 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 | |
| Conceptual, Logical and 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) | |
| MongoImport and MongoExport | |
| Data Manipulation | |
| Data Transfer (Same or cross server type) | |
| Data/Structure Synchronization | |
| Backup/Restore | |
| Backup/restore MySQL/MariaDB/PostgreSQL/SQLite database | |
| Convert backup file into SQL script | |
| MongoDump and MongoRestore | |
| Oracle Data Pump | |
| SQL Server Backup/Restore | |
| Dump/Execute SQL file | |
| Automation | |
| Set schedule on backup, MongoDump, MongoImport, MongoExport, MapReduce, 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 | |
| Schema Analysis | |
| ER Diagram view | |
| Virtual grouping | |
| Customize connection colorings | |
| Database wide search | |
| Favorites list | |
| Print database/schema/table structure | |
| Dark mode |
| MySQL 3.21 or later, Drizzle, OurDelta, and Percona Server | Enterprise Essentials |
| MariaDB 5.1 or later | Enterprise Essentials |
| MongoDB 3.0 or later | Enterprise Essentials |
| Oracle 8.1 or later ( macOS Edition starts from Oracle 9i ) | Enterprise Essentials |
| PostgreSQL 7.3 or later | Enterprise Essentials |
| SQLite 2 and 3 | Enterprise Essentials |
| SQL Server 2000 or later | Enterprise Essentials |
| Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud, Alibaba Cloud, Tencent Cloud, MongoDB Atlas, Huawei Cloud | Enterprise Essentials |
| Secure connection: SSH/HTTP/SSL | Enterprise Essentials |
| PAM and GSSAPI authentication | Enterprise Essentials |
| Kerberos and LDAP authentication | Enterprise Essentials |
| x.509 certificate authentication | Enterprise Essentials |
| Export/import connection settings | Enterprise Essentials |
| Collaboration: create projects, add members | Enterprise Essentials |
| Synchronize connections and queries | Enterprise Essentials |
| Synchronize models and virtual groups | Enterprise |
| Grid view, Tree view and JSON view | Enterprise Essentials |
| Form view | Enterprise |
| Foreign key data selection | Enterprise |
| Text, Hex, Image, Web or BFile viewer/editor | Enterprise Essentials |
| Raw mode editing | Enterprise Essentials |
| Data Validation | Enterprise Essentials |
| Customize data type colorings | Enterprise Essentials |
| Find and replace | Enterprise Essentials |
| Filter records | Enterprise Essentials |
| PL/SQL and PL/PGSQL Debugger | Enterprise |
| SQL/Script Editor | Enterprise Essentials |
| Visual SQL/Script Builder | Enterprise |
| Find Builder | Enterprise |
| Aggregate Builder | Enterprise |
| Code Snippet and Completion | Enterprise |
| SQL/Script Beautifier and Minifier | Enterprise |
| Find and replace | Enterprise Essentials |
| Create parameter queries | Enterprise Essentials |
| Open query files in an external editor | Enterprise Essentials |
| Console | Enterprise Essentials |
| Support 20 chart types | Enterprise |
| Visualize live data | Enterprise |
| Customize multiple pages dashboard | Enterprise |
| Add interactive controls | Enterprise |
| Conceptual, Logical and Physical model | Enterprise |
| Reverse/forward engineering | Enterprise |
| Auto layout | Enterprise |
| Add vertices, layers, images, notes, labels and shapes | Enterprise |
| Print database diagrams to PDF and graphic files | Enterprise |
| Import/export data from/to plain text file formats: TXT, CSV, XML, JSON | Enterprise Essentials |
| Import/export data from/to most popular formats: DBF etc | Enterprise |
| Import data from ODBC, MS Excel, MS Access | Enterprise |
| Export data to MS Excel, HTML | Enterprise |
| Export data to MS Access (Windows Edition only) | Enterprise |
| MongoImport and MongoExport | Enterprise Essentials |
| Data Transfer (Same or cross server type) | Enterprise |
| Data/Structure Synchronization | Enterprise |
Navicat Essentials For Postgresql Download
| Backup/restore MySQL/MariaDB/PostgreSQL/SQLite database | Enterprise |
| Convert backup file into SQL script | Enterprise |
| MongoDump and MongoRestore | Enterprise Essentials |
| Oracle Data Pump | Enterprise |
| SQL Server Backup/Restore | Enterprise |
| Dump/Execute SQL file | Enterprise Essentials |
| Set schedule on backup, MongoDump, MongoImport, MongoExport, MapReduce, query execution, import/export, data transfer and data synchronization | Enterprise |
| Run profiles from different servers in a single batch job | Enterprise |
| Include attachment for export file in notification email | Enterprise |
Navicat Essentials For Postgresql Free
| Manage user | Enterprise Essentials |
| Server Monitor | Enterprise |
Navicat Essentials For Postgresql Database
| Schema Analysis | Enterprise |
| ER Diagram view | Enterprise |
| Virtual grouping | Enterprise |
| Customize connection colorings | Enterprise Essentials |
| Database wide search | Enterprise |
| Favorites list | Enterprise |
| Print database/schema/table structure | Enterprise |
| Dark mode | Enterprise Essentials |