PgAdmin III 1.6.0 review

pgAdmin III is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The gra

License: Artistic License File size: 8057K Developer: pgAdmin Development Team

0

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.

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:
This release includes hundreds of enhancements and bugfixes, notably including a new dockable user interface, a greatly enhanced query tool, an XML/XHTML database schema reporting engine, and support for PostgreSQL 8.2.