pgAdmin 4是一款為PostgreSQL設(shè)計(jì)的可靠和全面的數(shù)據(jù)庫(kù)設(shè)計(jì)和管理軟件，它允許您連接到特定的數(shù)據(jù)庫(kù)，創(chuàng)建表和運(yùn)行各種從簡(jiǎn)單到復(fù)雜的SQL語(yǔ)句。它旨在回答所有用戶(hù)的需求，所以pgAdmin使您能夠執(zhí)行各種操作，從運(yùn)行簡(jiǎn)單的SQL查詢(xún)開(kāi)始到開(kāi)發(fā)復(fù)雜的數(shù)據(jù)庫(kù)。

特色功能

多平臺(tái)支持

Microsoft Windows、Linux、蘋(píng)果系統(tǒng)

廣泛的文檔

pgAdmin應(yīng)用程序文檔、PostgreSQL文檔鏈接

多個(gè)部署模型

桌面模式，使用專(zhuān)門(mén)構(gòu)建的運(yùn)行時(shí)、服務(wù)器模式，通過(guò)網(wǎng)絡(luò)支持多個(gè)用戶(hù)

強(qiáng)大的工具

顏色語(yǔ)法高亮查詢(xún)工具、用于顯示/輸入數(shù)據(jù)的快速數(shù)據(jù)網(wǎng)格、圖形查詢(xún)計(jì)劃顯示、授予向?qū)б钥焖俑�新ACL、程序語(yǔ)言調(diào)試器（支持pl / pgsql和edb-spl）

例行維修

自動(dòng)真空管理、監(jiān)視儀表板、備份，恢復(fù)，真空和需求分析、SQL / shell /批處理作業(yè)調(diào)度代理、創(chuàng)建，查看和編輯所有常見(jiàn)的PostgreSQL對(duì)象

、對(duì)象以其SQL定義和用戶(hù)友好的屬性列表顯示。依賴(lài)項(xiàng)和依賴(lài)項(xiàng)對(duì)象也可以被瀏覽，并在適當(dāng)?shù)臅r(shí)候查看對(duì)象統(tǒng)計(jì)信息。

更新日志

新增特性有：

新的平滑UI設(shè)計(jì)

允許查詢(xún)計(jì)劃下載存儲(chǔ)為SVG格式

增加容器部署選項(xiàng)

修復(fù)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.

功能?chē)L鮮：

UI改進(jìn) - 在扁平化風(fēng)格大行其道的今天，v4版本的新UI比以往的界面看起來(lái)更合群。

查詢(xún)計(jì)劃下載存儲(chǔ)為SVG格式 - 該功能在執(zhí)行計(jì)劃特別復(fù)雜是，可以幫助更清晰的了解計(jì)劃的細(xì)節(jié)

Docker部署 - 可以直接從Docker Hub上pull鏡像下來(lái)使用，暫時(shí)未體驗(yàn)