Whether you want to select specific commands or available properties of database objects, you can choose specific scripts from the drop-down list.įurthermore, you can even create a database model from an existing database and edit its structure using the ‘Reverse Engineer’ option.

What’s more, the application comes with a code completion feature so you can create SQL scripts effortlessly. All you have to do is to choose the operation you want to perform over the tables and generate all the SQL statements automatically. It is divided into two sections that allow you to view the tables (which are connected between their primary keys) and the syntax. Using the ‘SQL Builder’ option you are able to create and edit queries and views without having to learn the proper usage of commands.

The Object Designer function allows you to quickly create, modify and design database objects such as tables, functions and triggers, to name a few, set primary keys, view all the available foreign keys and preview the SQL script. Using this application you are able to connect to any local or remote PostgreSQL database server, create and execute queries, functions, triggers and SQL scripts, synchronize data and generate various reports effortlessly. Navicat for PostgreSQL comes in handy for database administrators and for users who need to quickly manage and organize as many PostgreSQL connections as they want.

Navicat pgsql