Web pgadmin.org
HomeAdvocacyDevelopmentDocumentationDownloadScreenshotsSupportTranslation

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 it's capabilities:

Multiplatform

  • Microsoft Windows ™ 2000 and above
  • Linux
  • FreeBSD
  • Mac OSX
  • Solaris

Designed for multiple PostgreSQL versions and derivatives

  • PostgreSQL 7.3 and above
  • Postgres Plus Advanced Server
  • Greenplum Database

Extensive documentation

  • pgAdmin Documentation
  • Guru Hints to help less experienced users
  • PostgreSQL documentation (on-line and off-line)
  • Slony-I documentation

Multilingual interface

  • Over 12 supported translations. A detailed list of supported languages is available on the translation status page.

Data access

  • Native PostgreSQL acccess (no ODBC layer needed)
  • Powerful query tool with colour syntax highlighting
  • Very fast datagrid for display/entry of data

Routine maintenance

  • Configuration file editing
  • Auto-vacuum management (PostgreSQL 8.1 and above)
  • Logfile browser
  • Lock viewer
  • Server status/process viewer
  • SQL/shell/batch job scheduling agent

Access to all 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
  • Conversions
  • Databases
  • Domains
  • FTS configurations
  • FTS dictionaries
  • FTS parsers
  • FTS templates
  • Functions
  • Greenplum objects (such as external tables, ressource queues)
  • Groups
  • Indexes
  • Languages
  • Operator classes
  • Operator families
  • Operators
  • pgAgent objects (such as jobs, schedules)
  • PostgreSQL servers
  • Postgres Plus Advanced Server objects (such as packages, procedures, synonyms)
  • Roles
  • Rules
  • Schemas
  • Sequences
  • Server-side languages (such as pl/pgsql, pl/perl, pl/python, etc.)
  • Slony-I objects (such as nodes, clusters etc.)
  • Tables
  • Tablespaces
  • Trigger functions
  • Types
  • Users
  • Views

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