PhpPgAdmin

phpPgAdmin is a fully functional web-based administration utility for a PostgreSQL database server, licensed under a free and open source license. Similar to phpMyAdmin, which phpPgAdmin was also based on, it is written in PHP and can be accessed with a web browser. PhpPgAdmin requires a web server with PHP, such as Apache or Nginx, and is therefore cross-platform.
The project originally started as a fork of phpMyAdmin, to provide PostgreSQL users with comparable services to what MySQL users had been using. However, in 2002, the code was re-written from scratch, and is now a completely different code base.
History
The history of phpPgAdmin can be found on their about page:<ref name=About />
Features
PhpPgAdmin has, among others, the following features:
* Administer multiple servers
* Support for PostgreSQL 9.0.x, 9.1.x, 9.2.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
* Supports the Slony master-slave replication engine
* Language support:
** Available in 27 languages
** No encoding conflicts. Edit Russian data using a Japanese interface
* Easy to install and configure
Current status
The software, which is currently - in version 5.1 - available in 27 languages,<ref name=Start /> is maintained by The phpPgAdmin Project.
 
< Prev   Next >