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
官方为FreeBSD、Linux、Mac OSX以及Microsoft Windows ™提供了源程序和二进制包,Solaris的二进制程序可以从源代码编译。
支持中文!
本文由用户 openkk 自行上传分享,仅供网友学习交流。所有权归原作者,若您的权利被侵害,请联系管理员。
转载本站原创文章,请注明出处,并保留原始链接、图片水印。
本站是一个以用户分享为主的开源技术平台,欢迎各类分享!