This is a database management system that is designed to help software developers build applications, administrators to organize and control multiple databases and protect data integrity. It is an open source system that is built on SQL language and extend its functionality by combining it with several other features, enabling it to perform all kinds of data operations.
The application comes with support for popular programming languages including Python, Java, Ruby, C, C++ and Perl, and it’s compatible with most operating systems.
The user interface is simple and intuitive with all the tools well laid out. At the left pane of the main window is an object browser which displays the structure of the available data servers and the objects within them such as databases, events triggers, extensions, tablespaces, and catalogs.
The SQL pane at the bottom shows a reverse engineered SQL script of your actions which can be saved, copy and pasted on any editor or any language that supports SQL scripts.
Any object you select on the hierarchical tree view will have its information (Properties, Statistics, Dependencies, and Dependents) listed out on the right section of the main window.
PostgreSQL is licensed as freeware for PC or laptop with Windows 32 bit and 64 bit operating system. It is in database utils category and is available to all software users as a free download.