Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing Navicat for PostgreSQL vs SQLGate, the Slant community recommends Navicat for PostgreSQL for most people. In the question“What are the best GUI tools for PostgreSQL on Windows?” Navicat for PostgreSQL is ranked 3rd while SQLGate is ranked 9th. The most important reason people chose Navicat for PostgreSQL is:
The Navicat UI is extremely quick to respond to requests.
Specs
Question Ranking
Pros
Pro Fast UI
The Navicat UI is extremely quick to respond to requests.
Pro Good autocomplete
Navicat offers a strong code completion feature.
Pro Saves queries by name
Pro Very stable
Pro Quick data analysis
Functions; filter, sort and group on grid / Copy, past, sum and statistics functions like excel.
Pro Saves time with autocomplete & template functions
Pro Fast processing and easy customization
They put out weekly updates, so there are new and impressive functions being added pretty consistently.
Pro Supports cloud-based DB such as AWS & Azure
Pro Includes PL/SQL editor and debugger
Pro ER diagrams
Entity Relationship database diagrams limitations are: only supports reverse engineering, and can not export to formats other than .erd
Cons
Con Expensive
Navicat is quite expensive at $149 for the standard edition, and $199 for enterprise.
Con Logon
The logon process after starting up the application is rather long winded (tested with PostgreSQL, no defaults shown for e.g. port number).
Con Free version is limited
e.g. only 10 tables allowed in ERD designer.
