pgAdmin III is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases.
The graphical interface of PgAdmin III supports all PostgreSQL features and makes administration easy.
The application also includes a query builder, an SQL editor, a server-side code editor and much more. pgAdmin III is released with an installer and does not require any additional driver to communicate with the database server.
pgAdmin III is developed by a community of database specialists around the world and is available in more than 30 languages. It is Free Software released under the Artistic License.
Product's homepage
Here are some key features of "PgAdmin III":
Multiplatform:
· MS Windows 2000 & XP
· GNU/Linux
· FreeBSD
· MacOsX and SunOS ports are under development.
Designed for PostgreSQL latest versions:
· PostgreSQL 7.3
· PostgreSQL 7.4
· PostgreSQL 8.0
On-line help:
· PostgreSQL documentation (on-line and off-line)
· SQL command guide
Multilingual interface:
· pgAdmin III user interface is translated in more than 30 languages. A detailed list of supported languages is available on the Translation page.
Data access:
· Native PostgreSQL acccess (no ODBC layer needed)
· Powerful query tool with color syntax highlight
· Very fast datagrid for display/entry of data
Access to all PostgreSQL objects:
· Objects are displayed with their SQL definition.
· Aggregates
· Casts
· Columns
· Constraints
· Conversions
· Databases
· Domains
· Functions
· Groups
· Indexes
· Tablespaces
· Server-side languages (like PLpgsql, PLpython, PLperl, etc...)
· Operator classes
· Operators
· PostgreSQL servers
· Rules
· Schemas
· Sequences
· Tables
· Trigger function
· 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
Requirements:
· PostgreSQL
What's New in This Release: [ read full changelog ]
· Correctly save the position of a pgFrame, per a report from Andreas Laggner and Dan Halbert.
· Fix the reverse engineering of a function, per a report from Kieran McCusker.
· Fix the xmlTextWriterEndDocument check when saving a favorite.
· Fix an SQL error when changing a parameter for a database, role/user and a function.
· Fix the display of a type with a specific typmod.
· Select the server choosen with the /s command-line argument.
· Fix the call to the Slony-I storenode function.
· Fix display of the date/time chooser.