pgAdmin

PostgreSQL Tools

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

pgAdmin may be used on Linux, Unix, Mac OS X and Windows to manage PostgreSQL 9.2 and above.

News

2018-04-13 - pgAdmin 4 v3.0 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 3.0. This release of pgAdmin 4 includes over 100 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • The desktop runtime now runs as a system tray application and utilises the browser on the system to display pgAdmin. This resolves numerous bugs and issues caused by QtWebKit/QtWebEngine.
  • Data can now be sorted in edit mode in the Query Tool.
  • Keyboard navigation with configurable shortcuts for many operations has been added to allow use of pgAdmin without a mouse.
  • Dashboard tables and charts can be enabled/disabled.
  • Server and database statistics, functions, partitions, external tables and EXPLAIN are now supported on Greenplum.
  • Support for pg_service.conf files has been added.
  • The Docker Container distribution is vastly slimmed down, having move to Alpine Linux with Gunicorn to host the pgAdmin web application.

Download your copy here.

2018-01-11 - pgAdmin 4 v2.1 Released

The pgAdmin Development Team are pleased to announce pgAdmin 4 version 2.1. This release of pgAdmin 4 includes nearly 90 bug fixes and new features. For more details please see the release notes here.

Notable changes in this release include:

  • Support for colouring connections in the treeview and query tool
  • Configurable formatting for CSV and clipboard datasets
  • Editing of table data for tables with OIDs but no primary keys
  • Immediately retrieve default column values when saving new/edited rows in the query tool

We've also added a new distribution in the form of a Docker Container. See the Docker Hub repo for more information.

Download your copy of pgAdmin here.

2017-07-13 - pgAdmin 4 v1.6 released

The pgAdmin Development Team are pleased to announce the release of pgAdmin 4 version 1.6. This release of pgAdmin 4 includes over 70 bug fixes and a dozen new features. For details, please see the release notes.

Notable changes in this release include:

  • Significant performance improvements on Windows, massively reducing initial load time and improving UI response for the vast majority of users during testing.
  • Enhancements to the Query Tool enabling the viewing of large query resultsets far more quickly. For example, a simple test query with 96K rows rendered results within 1 second vs. 22 seconds in pgAdmin III during testing!
  • A major rewrite of the Query History tab allows browsing of queries executed in the query tool with full details including the entire query, in a much nicer user interface.
  • The Desktop Runtime now supports detachable tabs, allowing the Query Tool and Debugger to be opened in new tabs and then moved to alternate displays (from 1.5 this was possible in web mode only)
  • The Query Tool's Results Grid has been overhauled with a new, sleek look an feel supporting selection of arbitrary rows, columns or blocks of cells with full copy support and column sizing retention.
  • The Dashboard tab can now be closed if desired, to minimise query traffic resulting from graph updates.

For more information, checkout the online documentation, the screenshots, and of course the download page.

The current version of pgAdmin 4 is 3.0