pgAdmin 4是一款为PostgreSQL设计的可靠和全面的数据库设计和管理软件,它允许您连接到特定的数据库,创建表和运行各种从简单到复杂的SQL语句。它旨在回答所有用户的需求,所以pgAdmin使您能够执行各种操作,从运行简单的SQL查询开始到开发复杂的数据库。
特色功能
多平台支持
Microsoft Windows、Linux、苹果系统
广泛的文档
pgAdmin应用程序文档、PostgreSQL文档链接
多个部署模型
桌面模式,使用专门构建的运行时、服务器模式,通过网络支持多个用户
强大的工具
颜色语法高亮查询工具、用于显示/输入数据的快速数据网格、图形查询计划显示、授予向导以快速更新ACL、程序语言调试器(支持pl / pgsql和edb-spl)
例行维修
自动真空管理、监视仪表板、备份,恢复,真空和需求分析、SQL / shell /批处理作业调度代理、创建,查看和编辑所有常见的PostgreSQL对象
、对象以其SQL定义和用户友好的属性列表显示。依赖项和依赖项对象也可以被浏览,并在适当的时候查看对象统计信息。
更新日志
新增特性有:
新的平滑UI设计
允许查询计划下载存储为SVG格式
增加容器部署选项
修复bug列表如下:
Bug #3083 - Increase the size of the resize handle of the edit grid text pop-out.
Bug #3354 - Fix handling of array types as inputs to the debugger.
Bug #3433 - Fix an issue that could cause the Query Tool to fail to render.
Bug #3549 - Display event trigger functions correctly on EPAS.
Bug #3559 - Further improvements to treeview restoration.
Bug #3599 - Run Postfix in the container build so passwords can be reset etc.
Bug #3619 - Add titles to the code areas of the Query Tool and Debugger to ensure that panels can be re-docked within them.
Bug #3679 - Fix a webpack issue that could cause the Query Tool to fail to render.
Bug #3702 - Ensure we display the relation name (and not the OID) in the locks table wherever possible.
Bug #3711 - Fix an encoding issue in the query tool.
Bug #3726 - Include the WHERE clause on EXCLUDE constraints in RE-SQL.
Bug #3753 - Fix an issue when user define Cast from smallint->text is created.
Bug #3757 - Hide Radio buttons that should not be shown on the maintenance dialogue.
Bug #3780 - Ensure that null values handled properly in CSV download.
Bug #3796 - Tweak the wording on the Grant Wizard.
Bug #3797 - Prevent attempts to bulk-drop schema objects.
Bug #3798 - Ensure the browser toolbar buttons work in languages other than English.
Bug #3805 - Allow horizontal sizing of the edit grid text pop-out.
Bug #3809 - Ensure auto complete should works when first identifier in the FROM clause needs quoting.
Bug #3810 - Ensure auto complete should works for columns from a schema-qualified table.
Bug #3821 - Ensure identifiers are properly displayed in the plan viewer.
Bug #3830 - Make the setup process more robust against aborted executions.
Bug #3856 - Fixed an issue while creating export job.
功能尝鲜:
UI改进 - 在扁平化风格大行其道的今天,v4版本的新UI比以往的界面看起来更合群。
查询计划下载存储为SVG格式 - 该功能在执行计划特别复杂是,可以帮助更清晰的了解计划的细节
Docker部署 - 可以直接从Docker Hub上pull镜像下来使用,暂时未体验