The pgAdmin Development Team are pleased to announce pgAdmin 4 version 5.6. This release of pgAdmin 4 includes 14 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:

• Added support to copy SQL from the main window to the query tool.

  This feature is used to copy the SQL script for the selected browser tree node in the query tool. For this we have added new preferences setting ‘Copy SQL from main window to query tool?’

• Added support for formatted JSON viewer/editor when interacting with data in a JSON column

  This feature allows the user to format, view and edit JSON data in a very nice way. JSON editors have so many formats to view data differently.

Bugs/Housekeeping:

• Rename the "Resize by data?" to "Columns sized by" and disabled the 'Maximum column width' button if 'Columns sized by' is set to 'Column data'.
• Ensure that the login account should be locked after N number of attempts. N is configurable using the 'MAX_LOGIN_ATTEMPTS' parameter.
• Fixed CSRF errors for stale sessions by increasing the session expiration time for desktop mode.
• Fixed an issue in the search object when searching in 'all types' or 'subscription' if the user doesn't have to access to the subscription.
• Fixed an issue where the paste was not working through the Right-Click option on PSQL.
• Fixed TypeError 'NoneType' object is not sub scriptable.
• Fixed an issue where the titles in query tabs are different.
• Fixed dashboard server activity issue when active_since parameter is None.

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.