pgAdmin III is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world. The application may be used on Linux, FreeBSD, OpenSUSE, Solaris, Mac OSX and Windows platforms to manage PostgreSQL 7.3 and above running on any platform, as well as commercial and derived versions of PostgreSQL such as EnterpriseDB, Mammoth PostgreSQL, Bizgres and Greenplum database.

pgAdmin III is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more. Server connection may be made using TCP/IP or Unix Domain Sockets (on *nix platforms), and may be SSL encrypted for security. No additional drivers are required to communicate with the database server.

pgAdmin III is developed by a community of PostgreSQL experts around the world and is available in more than a dozen languages. It is Free Software released under the Artistic License.

 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:

Multilingual interface

• Over a dozen supported translations and over 25 partial 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
• Functions
• Groups
• Indexes
• Operator classes
• Operators
• PostgreSQL servers
• 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 III 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