phpPgAdmin

phpPgAdmin is a web-based administration tool for PostgreSQL. phpPgAdmin is perfect for PostgreSQL DBAs, newbies and hosting services.

Here are some key features of "phpPgAdmin":

- Administer multiple servers
- Support for PostgreSQL 7.0.x, 7.1.x, 7.2.x, 7.3.x, 7.4.x and 8.0.x
- Manage all aspects of:
- Users & groups
- Databases
- Schemas
- Tables, indexes, constraints, triggers, rules & privileges
- Views, sequences & functions
- Advanced objects
- Reports
- Easy data manipulation:
- Browse tables, views & reports
- Execute arbitrary SQL
- Select, insert, update and delete
- Dump table data in a variety of formats: SQL, COPY, XML, XHTML, CSV, Tabbed, pg_dump
- Import SQL scripts, COPY data, XML, CSV and Tabbed
- Excellent language support:
- Available in 24 languages
- No encoding conflicts. Edit Russian data using a Japanese interface!
- Easy to install and configure

What is new in this release:

• This update brings some bugfixes, compatibility changes, and and code cleanups.

What is new in version 5.0:

• Features:
• Support for PostgreSQL 8.4 and 9.0
• Support for database-level collation for 8.4+
• Support for schema-level export
• Add ability to alter schema ownership
• Clean up domain support and improve interface
• Add support for commenting on functions
• Allow user to rename role/users and set new passwords at the same time
• Greatly enhanced Full-Text-Search capabilities (ioguix, Loomis_K)
• Overhauled Selenium Test suite to support multiple database versions
• Optimized application graphics (Limo Driver)
• Support for Column Level Privileges
• Allow users to specify a template database at database creation time
• Support killing processes
• Add ability to create indexes concurrently
• Much better support of autovacuum configuration
• Add an admin page for table level
• Refactored autocompletion:
• fix support for cross-schema objects
• support multi-field FK
• support for pagination of values in the auto-complete list
• Allow user to logicaly group their server under custom named node in the browser tree
• Add a theme switcher on the introduction page
• Add themes "Blue/Green" by Tomasz Pala and "Cappuccino" by ioguix
• Auto refresh Locks page
• Auto refresh Processes page
• Link in the bottom of the page to go to top of page
• Browsing on Foreign Keys (When browsing a table, clicking on a FK value, jump to the PK row)
• Translations:
• added Czech (Marek Cernocky)
• added Greek (Adamantios Diamantidis)
• added Galician (Adri=E1n Chaves Fern=E1ndez)
• added Brazillian Portuguese (Fernando Wendt)
• Updated Spanish translation(Miguel Useche)
• Updated French translation (JG 'ioguix' de Rorthais)
• Updated Catalan translation (Bernat Pegueroles)
• Bug Fixes:
• Fix problems with query tracking on overly long queries
• Ensure pg_dump paths are valid
• Fix multiple bugs about quoting and escaping database objects names with special chars
• Fix multiple bugs in the browser tree
• Fix multiple bugs on the SQL and script file import form
• One security fix about code injection
• Don't allow inserting on a table without fields
• Some fix about commenting databases
• removed deprecated functions from PHP 5.3
• Lot of code cleanup
• Many other small minor bugs found on our way
• Fix bug #3068680 "child tables info uses wrong field name", reported by langerheiko
• Fix bug #3071816 "First column in a SQL result missing", reported by Yilmaz ULKUSAL
• Multiple fixes about auto-completing Foreign Keys in forms, one bug reported by Dmitry Koterov
• Fix bug #2876417 "SQL window too small size to see bottom buttons (Execute)", reported by Philippe Cloutier
• A tryout to fix some bad escaped chars that are breaking the left browser tree with some specific locale configuration
• Remove "display_errors =3D on" by default (only useful during development)
• Re-enable the edit privilege button for functions. Reported by Jaroslav Hansl=EDk
• Fix #3081361 "UPDATE NOT OK in 5.0-beta2", reported by Der Michel
• Fix for bug #3092826 "schema owner is blank for role with nologin", reported by Sompop
• Fix bug "double-escaping of non-latin 'All servers' message fix", reported by Denis Orlikhin
• Compatibility fix for the operator properties page
• Incompatabilities:
• No longer support PHP < 5.0
• No longer support Postgres < 7.4

What is new in version 4.2.3:

• Fix bug where space as first character in a bytea column was removed by html renderer
• Check if the given pg_dumpall / pg_dump paths are correct before using them
• Fix some transalation files that had bad UTF-8 declaration, rising a warning
• Fix bug with tables that contain quote in their name
• Support PHP 5.3