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.5 and above
- EDB Postgres Advanced Server 9.5 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)
- 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