PostgreSQL管理接口 pgAdmin

openkk 12年前發布 | 56K 次閱讀 數據庫管理工具 PostgreSQL

PostgreSQL管理接口 pgAdmin
pgAdmin是一個針對PostgreSQL數據庫的全面設計和管理接口，可以在大多數操作系統上運行。軟件用C++編寫，采用了優秀的wxWidgets跨平臺工具包。在每一個環境下，pgAdmin III都是一個本地化程序，以二進制方式執行，而不是虛擬機，具有很優秀的性能。

pgAdmin has a huge array of features and by far the best way to see them all is to download a copy and give it a try. Here's a brief list to give you an idea of it's capabilities:

Multiplatform

  • Microsoft Windows ? 2000 and above
  • Linux
  • FreeBSD
  • Mac OSX
  • Solaris

Designed for multiple PostgreSQL versions and derivatives

  • PostgreSQL 7.3 and above
  • Postgres Plus Advanced Server
  • Greenplum Database

Extensive documentation

  • pgAdmin Documentation
  • Guru Hints to help less experienced users
  • PostgreSQL documentation (on-line and off-line)
  • Slony-I documentation

Multilingual interface

  • Over 12 supported translations. A detailed list of supported languages is available on the translation status page.

Data access

  • Native PostgreSQL acccess (no ODBC layer needed)
  • Powerful query tool with colour syntax highlighting
  • Very fast datagrid for display/entry of data

Routine maintenance

  • Configuration file editing
  • Auto-vacuum management (PostgreSQL 8.1 and above)
  • Logfile browser
  • Lock viewer
  • Server status/process viewer
  • SQL/shell/batch job scheduling agent

Access to all PostgreSQL objects

Objects are displayed with their SQL definition, and a user friendly list of properties. Dependent, and dependency objects may also be browsed, and object statistics viewed where appropriate.

  • Aggregates
  • Casts
  • Columns
  • Constraints
  • Conversions
  • Databases
  • Domains
  • FTS configurations
  • FTS dictionaries
  • FTS parsers
  • FTS templates
  • Functions
  • Greenplum objects (such as external tables, ressource queues)
  • Groups
  • Indexes
  • Languages
  • Operator classes
  • Operator families
  • Operators
  • pgAgent objects (such as jobs, schedules)
  • PostgreSQL servers
  • Postgres Plus Advanced Server objects (such as packages, procedures, synonyms)
  • Roles
  • Rules
  • Schemas
  • Sequences
  • Server-side languages (such as pl/pgsql, pl/perl, pl/python, etc.)
  • Slony-I objects (such as nodes, clusters etc.)
  • Tables
  • Tablespaces
  • Trigger functions
  • Types
  • Users
  • Views

Multibyte support

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

PostgreSQL管理接口 pgAdmin

官方為FreeBSD、Linux、Mac OSX以及Microsoft Windows ?提供了源程序和二進制包，Solaris的二進制程序可以從源代碼編譯。

支持中文！

項目主頁：http://www.baiduhome.net/lib/view/home/1340010278408

 本文由用戶 openkk 自行上傳分享，僅供網友學習交流。所有權歸原作者，若您的權利被侵害，請聯系管理員。
 轉載本站原創文章，請注明出處，并保留原始鏈接、圖片水印。
 本站是一個以用戶分享為主的開源技術平臺，歡迎各類分享！