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

pgAdmin supports the versions of PostgreSQL and EDB Postgres Advanced Server that are in support at the time of the release of any given version of pgAdmin.

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
  • ERD Tool for designing and documenting 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.

  • Casts
  • Catalog Objects
  • Catalogs
  • Check Constraints
  • Collations
  • Columns
  • Compound Triggers
  • Constraints
  • Databases
  • Domain Constraints
  • Domains
  • Event Triggers
  • Exclusion Constraints
  • Extensions
  • FTS Configurations
  • FTS Dictionaries
  • FTS Parsers
  • FTS Templates
  • Foreign Data Wrappers
  • Foreign Keys
  • Foreign Servers
  • Foreign Tables
  • Functions
  • Indexes
  • Languages
  • Login/Group Roles
  • Materialized Views
  • Package Functions
  • Package Procedures
  • Packages
  • Partitions
  • Primary Key
  • Procedures
  • Publications
  • RLS Policies
  • Resource Groups
  • Rules
  • Schedules
  • Schemas
  • Sequences
  • Steps
  • Subscriptions
  • Synonyms
  • Tables
  • Tablespaces
  • Trigger Functions
  • Triggers
  • Types
  • Unique Constraint
  • User Mappings
  • Variables
  • Views
  • pgAgent Jobs
  • pgAgent Schedules
  • pgAgent Steps

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