pgAdmin is an Open Source tool that allows multi-database management through an administration interface for PostgreSQL permitting statement, procedure viewing and more.

pgAdmin allows multi-database management through an administration interface for PostgreSQL permitting statement, procedure viewing and more.

It allows you to write simple SQL queries or to develop complex databases all with the support of PostgreSQL functions. pgAdmin is designed for both novice and experienced Postgres users alike. pgAdmin provides a powerful graphical interface that simplifies the creation, maintenance and use of database objects. You can perform different actions like running simple SQL queries all the way up to developing complex databases. It includes many useful features including syntax highlighting, SQL editor, procedural code debugger, and a server-side code editor to name a few.

pgAdmin additionally provides you with a Graphical Query Builder (GQB) option. This option enables visually building SQL queries and executing or saving them to a TXT file. There is also a ‘Query Tool Macros’ for performing pre-defined SQL queries in as little as a single key press. You also have access to embedded instructions for all aspects of use including multi-database management or how to properly set up SQL triggers and execute SQL scripts.

 Download