The pgAdmin Development Team is pleased to announce pgAdmin 4 version 9.3. This release of pgAdmin 4 includes 4 new features and 14 bug fixes/housekeeping changes. 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 type constructors for PostGIS spatial types.
• Added ability to use SQL in the "DB Restriction" field.
• Add support for custom roles and role permissions management in pgAdmin.
• Added support for font ligatures.

Bugs/Housekeeping:

• Add Cache-Control no-cache,no-store,must-revalidate header to dynamically generated utils.js file.
• Fixed an issue where shift + click on rows/columns for range selection did not work in the query tool data output window.
• Fixed an issue where the debugger hangs when stepping into nested function/procedure.
• Ensure that graph data is updated even when the Dashboard tab is inactive.
• Fixed an issue where Ctrl/Cmd+A in cell editor would select all rows.
• Fixed an issue where drag and drop function with no parameters does not work.
• Fixed an issue where changes to foreign key constraints were not detected in the schema diff.
• Fixed an issue where the query tool went blank when converting history dates to the appropriate locale format.
• Fixed an issue where the user management tab is not opening in the classic layout.
• Allow OAuth 2 login using the username claim if the email is absent from the user profile.

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