HomeDevelopmentDocumentationDownloadScreenshotsSupport

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

top