A web based administration tool for the PostgreSQL database!

pgAdmin

pgAdmin

  -  193 MB  -  Freeware
  • Latest Version

    pgAdmin 4 8.14 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    Windows 8 (64-bit) / Windows 10 (64-bit) / Windows 11

  • User Rating

    Click to vote
  • Author / Product

    pgAdmin Team / External Link

  • Filename

    pgadmin4-8.14-x64.exe

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 is a management tool for PostgreSQL and derivative relational databases such as EnterpriseDB's EDB Advanced Server. It may be run either as a web or desktop application.

Features and Highlights
  • Desktop mode, using a purpose-built runtime
  • Server mode, supporting multiple users over the web
  • Powerful query tool with color syntax highlighting
  • Fast datagrid for display/entry of data
  • Graphical query plan display
  • Grant Wizard for rapid updates to ACLs
  • Procedural language debugger (supporting pl/pgsql and edb-spl)
  • Auto-vacuum management
  • Monitoring dashboard
  • Backup, restore, vacuum and analyze on-demand
  • SQL/shell/batch job scheduling agent
  • Create, view and edit all common PostgreSQL objects
  • Designed for multiple PostgreSQL versions and derivatives
pgAdmin supports most PostgreSQL server-side encodings:
  • SQL_ASCII
  • EUC_JP, EUC_CN, EUC_KR, EUC_TW
  • JOHAB
  • LATIN1, LATIN2, LATIN3, LATIN4, LATIN5, LATIN6, LATIN7, LATIN8, LATIN9, LATIN10
  • ISO_8859_5, ISO_8859_6, ISO_8859_7, ISO_8859_8
  • UNICODE/UTF-8
  • MULE_INTERNAL
  • KOI8
  • WIN
  • ALT
  • WIN1256
  • TCVN
  • WIN874


  • pgAdmin 4 8.14 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    pgAdmin 4 8.14 Screenshot 1
  • pgAdmin 4 8.14 Screenshot 2
  • pgAdmin 4 8.14 Screenshot 3
  • pgAdmin 4 8.14 Screenshot 4
  • pgAdmin 4 8.14 Screenshot 5

What's new in this version:

New features:
- Allow setting NULL ordering for columns in view/edit data filter dialog
- Show auto-complete column names in filtered rows dialog of table and filter options of view/edit data tool
- Allow the use of a pgpass file in the pgAdmin container via Docker secrets
- Fixed multiple issues and improved ERD auto-layout
- Add support for passing connection details as placeholders in the passexec command
- Add support to deploy pgAdmin in a container with readOnlyRootFilesystem to true
- Added support for a builtin locale provider in the Database dialog
- Added support for adding tags on a server node

Fixed:
- Fixed an issue where Ctrl/Cmd + A was not selecting all data in query tool data grid
- Fixed an issue where querying a foreign table gives the error ‘ForeignTableCommand’ object has no attribute ‘auto_commit’
- Fixed an issue where indent with space was not aligning to next tab position
- Fixed an issue where pgAdmin crashes on accessing the dashboard state tab when database is super busy
- Fixed an issue related to the query tool update connection after the server disconnected from the object explorer
- Fixed an issue where a column name change in the edit dialog of the table node does not show the updated column name
- Fixed an issue where query tool should show results and messages only from the last executed query
- Fixed an issue where query tool throws syntax error if a newly added row is untouched and saved
- Ensure the crypt key is retrieved correctly on backend server restart
- Fixed an issue in schema diff where an error message popup was showing some garbage without any info
- Fixed an issue where query tool should not prompt for unsaved changes when there are no changes
- Add a user preference to enable/disable alternating row background colors in the data output of query tool
- Fixed an issue where doing Ctrl/Cmd+C on a selected text in a cell editor of data output in the query tool copied the complete text
- Fixed an issue where auto-width of wide columns in data output is incorrectly calculated
- Ensure correct custom SSL certificate passed in connection string