Features

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 its capabilities:

Multiplatform

Microsoft Windows ™
Linux
macOS

Designed for multiple PostgreSQL versions and derivatives

PostgreSQL 9.2 and above
EDB Postgres Advanced Server 9.2 and above

Extensive documentation

pgAdmin application documentation
PostgreSQL documentation links

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)

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

Quick Links