pgAdmin 4 v6.0 Released

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

Introduction to ReactJS Framework in pgAdmin 4:

ReactJS has a strong developer community and popularity. It has grown to a level where its performance is comparable to that of desktop applications. Migrating pgAdmin to use ReactJS has proven to boost pgAdmin’s performance and user experience.

In this release we have ported the browser Tree, all the object dialogs, and the Grant Wizard.

Features:

• Added support for OWNED BY Clause for sequences.

  This feature adds the OWNED BY clause for the sequences. The OWNED BY option causes the sequence to be associated with a specific table column, such that if that column (or its whole table) is dropped, the sequence will be automatically dropped as well.

Bugs/Housekeeping:

• Port object nodes and properties dialogs to React.
• Port browser tree to React.
• Port Grant Wizard to react.
• Remove GPDB support completely.
• Added support to create the Partitioned table using COLLATE and opclass.
• Fixed keyerror issue in schema diff for 'attnum' and 'edit_types' parameter.
• Fixed an issue where the Execute button of the query tool gets disabled once we change anything in the data grid.
• Ensure that SQL help should work for EPAS servers.
• Fixed an issue where the grant wizard is unresponsive if the database size is huge.

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.

Note: The publication of the python package to PyPi has been delayed and will be completed as soon as possible.