pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL.

Features

Multiple deployment models

• Desktop mode, using a purpose built runtime
• Server mode, supporting multiple users over the web

Tools

• Powerful query tool with colour 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)
• Schema diff tool for managing differences between schemas

Routine maintenance

• 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

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
• Databases
• Domains
• Foreign tables
• Foreign servers
• Foreign data wrappers
• FTS configurations
• FTS dictionaries
• FTS parsers
• FTS templates
• Functions
• Indexes
• Languages
• Materialized views
• Roles
• Rules
• Procedural languages
• Schemas
• Sequences
• Tables
• Tablespaces
• Trigger functions
• Types
• Views
• EDB Postgres Advanced Server objects (such as packages, procedures and synonyms)
• pgAgent objects (such as jobs, schedules)

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