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, macOS and Windows to manage PostgreSQL and EDB Advanced Server 10 and above.

Screenshot of pgAdmin

Latest Videos

Want to see your pgAdmin video here? Email webmaster@pgadmin.org.

Latest Blog Posts

Autocomplete feature in Query Tool

Author: Akshay Joshi, date: June 10, 2022

To use autocomplete, begin typing your query; when you would like the query editor to suggest object names or commands that might be next in your query, press the Control + Space key combination. For example, type "SELECT * FROM " (without quotes, but with a trailing space), and then press the Control + Space key combination to select from a popup menu of autocomplete options.

Read more

pgAdmin 4 Architecture

Author: Yogesh Mahajan, date: May 27, 2022

pgAdmin 4 is the leading Open Source management tool for Postgres. pgAdmin is designed to monitor and manage multiple PostgreSQL and EDB Advanced Server database servers, both local and remote, through a single graphical interface that allows the easy creation and management of database objects, as well as a number of other tools for managing your databases.

pgAdmin can be installed in two modes: Desktop & Server mode. Desktop mode is installed as a standalone application being used by the same operating system user while server mode can be accessed over the network, allowing it to be used by multiple users.

Both mode implementations follow a 3 tier architecture approach. This blog explains the pgAdmin architecture and technologies used in both modes.

Read more

Query Tool vs View/Edit Data

Author: Nikhil Mohite, date: May 10, 2022

Ever wondered what the differences are between the Query Tool and View/Edit Data tool in pgAdmin? In this blog Nikhil explains those differences and when each tool should be used.

Read more

Want to see your pgAdmin blog post here? Email webmaster@pgadmin.org.

News

2022-06-30 - pgAdmin 4 v6.11 Released

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.11. This release of pgAdmin 4 includes 20 bug fixes and new features. For more details please see the release notes.

Notable changes in this release include:

Features:

  • Added support for visualise the graph using a Line chart in the query tool.
  • With this feature, users can visualize the query result set as a Line chart. A new button 'Graph Visualiser' has been added to the Data output panel.

  • Added capability to deploy PostgreSQL servers on Microsoft Azure.
  • With this feature, users can deploy PostgreSQL on Microsoft Azure Cloud.

  • Added support for passing password using Docker Secret to Docker images.
  • This feature enabled pgAdmin docker image to pass passwords using docker secret.

  • Added mouse over indication for breakpoint area in the Debugger.
  • Added search text option to the Debugger panel.
  • Added the option 'Show template databases?' to display template databases regardless of the setting of 'Show system objects?'.

Bugs/Housekeeping:

  • Port Debugger to React.
  • Upgrade Chartjs and pgcli to the latest.
  • Fixed an issue where passwords entered in the 'Connect To Server' dialog were truncated.
  • Fixed an issue where there is no setting to turn off notifications in the Query Tool.
  • Fixed an issue where 'Use spaces' not working in the query tool.
  • Fixed an issue where the Database restriction is not working.
  • Fixed an issue where pgAdmin stuck while creating a new index.

Download your copy now!

2022-06-02 - pgAdmin 4 v6.10 Released

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.10. This release of pgAdmin 4 includes 23 bug fixes and new features. For more details please see the release notes.

Notable changes in this release include:

Features:

  • Added the ability to resize columns on dashboard tables.

Bugs/Housekeeping:

  • Port connect server password dialog to React.
  • Fixed the browser tree overlapping nodes and expansion issue.
  • Added the ability to detect and warn users about bidirectional Unicode characters.
  • Tell Docker to always pull the latest base images when building containers.
  • Fixed an issue with geometry window zoom mouse scroll not working.
  • Added support for multi-cell selection in the query tool grid.
  • Fixed an issue where an error message fills the entire window if the query is long.
  • Fixed an issue where geometry is not visible when a single cell is selected.
  • Fixed an issue where comments on domain constraints were not visible when selecting a domain node.
  • Ensure that null values are accepted for the numeric columns in react-data-grid.

Download your copy now!

2022-05-12 - pgAdmin 4 v6.9 Released

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.9. This release of pgAdmin 4 includes 29 bug fixes and new features. For more details please see the release notes.

Notable changes in this release include:

Features:

  • Port query tool to React.
  • This feature is a major revamp to the query tool in terms of the GUI. Some other related features have also been added to this. Some major enhancements are adding a status bar, toolbar buttons shown on the respective panels, fixing the headers of the slick grid, and many more.

  • Added options 'Ignore owner' and 'Ignore whitespace' to the schema diff panel.
  • This feature introduces the ‘ignore owner’ and ‘ignore whitespace’ options on the schema diff panel itself to provide the ease to the users to change the setting and compare the databases or schemas.

  • Added capability to deploy PostgreSQL servers on EDB BigAnimal.
  • This feature allows the users to deploy the PostgreSQL and EDB Advanced Server on the EDB BigAnimal Cloud.

  • Added status bar to the Query Tool.
  • Ensure that row numbers should be visible in view when scrolling horizontally.
  • Relocate GIS Viewer Button to the Left Side of the Results Table.
  • Added support for Azure AD OAUTH2 authentication.

Bugs/Housekeeping:

  • Only set permissions on the storage directory upon creation.
  • Improvement to the Geometry Viewer popup to change the size of the result tables when column names are quite long.
  • Fixed an issue where the downloaded ERD diagram was 0 bytes.
  • Don't strip binaries when packaging them in the server RPM as this might break cpython modules.
  • Ensure that Columns should always be visible in the import/export dialog.
  • Fixed an issue where the copy and paste row does not work if the first column contains no data.
  • Fixed an issue where the Browser panel is not completely viewable.
  • Fixed sorting issue in the statistics panel.
  • Ensure that sorting should be preserved on refresh for Server Activity.
  • Fixed an issue where the drag and drop table in ERD throws an error.

Download your copy now!

2018-07-12 - pgAgent v4.0.0 Released

The pgAdmin Development Team are pleased to announce the release of pgAgent v4.0.0.

pgAgent is a job scheduler for PostgreSQL; for more information please see the documentation included as part of the pgAdmin documentation at https://www.pgadmin.org/docs/pgadmin4/3.x/pgagent.html.

Download (source): https://www.pgadmin.org/download/pgagent-source-code/

We expect DEB and RPM packages to be available from the PostgreSQL APT/YUM repositories in due course, as well as an updated installer from EnterpriseDB available through StackBuilder.

Notable changes in this release include:

  • Remove the dependency on wxWidgets. pgAgent now uses Boost for thread management and synchronisation [Neel Patel]
  • Refactor connection parsing logic to fix issues with and improve handling of connection strings [Thomas Krennwallner]
  • Handle 2 digit server version numbers [Ashesh Vashi]
  • Fix handling of the "succeeded" flag on job steps which could prevent failure of steps causing the following steps to fail [Sanket Mehta]

The current version of pgAdmin 4 is 6.11

Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada, and used with their permission.