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

pgAdmin is the leading open-source graphical management tool for PostgreSQL. For more information, please see the website.

Notable changes in this release include:

Features:

• Add support for automatic updates in the pgAdmin 4 Desktop application on macOS.
• Added GENERIC_PLAN, MEMORY, and SERIALIZE options to EXPLAIN/EXPLAIN ANALYZE command.
• Add support for changing the cursor blink rate within the editors.
• Add support for server tag-based filtering in the Object Explorer.
• Added support for builtin locale provider while creating Collation.

Bugs/Housekeeping:

• Introduced an ‘Editor’ preferences category and migrated all editor related settings into it.
• Fixed an issue where CPU usage was very high on Windows when opening the psql tool.
• Fixed an issue where adding breakpoints caused errors, and stepping out of a nested function removed breakpoints from the parent function.
• Fixed an issue where custom column widths in the result grid of Query Tool or View/Edit Data were reset after re-executing a query.
• Fixed the issue where updating the name of a table column does not reflect in the corresponding primary key constraint.
• Make Dashboard tables to be vertically resizable.
• Fixed the incorrect behaviour of the option deduplicate items after creating the index.
• Added PKEY index in the index statistics summary.
• Fixed an issue where downloading images on the ERD tool was not working in desktop mode.
• Ensure the scratch pad in the Query Tool is not restored after it is closed.

Builds for Windows and macOS are available now, along with a Python Wheel, Docker Container, RPM, DEB Package, and source code tarball from the tarball area.