Free open-source software with a graphical interface.
It has rich features for both software developers and database administrators.
It can run on Linux, Mac and Windows platforms.
You can download and install it from pgadmin.org.
For Linux clients, the pgadmin4-desktop version is easier to install.
The installation and configuration of the server version involves long steps
General features:
- SQL tool that can have commands in different colors.
- Visual execution plan.
- ERD tool.
- Dashboard where instant events can be viewed.
- PL/pgSQL debugger.
- Assesment between different schemas.
- DDL extractor (create script).
- Vacuum analyze backup/restore.
- SQL/Shell/Batch job scheduling.
Postgres or any other database name you manage can be written on the
Maintenance database tab for example dvdrental.
Database server, Databases–> Schemas –> tables are followed to reach
the desired objects.
When you right click on the table, it lists the operations that can be performed.