Jump to content

phpPgAdmin

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by 77.35.18.108 (talk) at 06:15, 29 January 2011. The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.
phpPgAdmin
Stable release
5.0.2 / January 3, 2011 (2011-01-03)
Repository
Written inPHP and JavaScript
Operating systemCross-platform
TypeWeb Database Management
LicenseGNU General Public License
Websitehttp://phppgadmin.sourceforge.net

phpPgAdmin is a web application, written in PHP, for managing PostgreSQL databases.

phpPgAdmin is a web-based client which leverages PHP scripting and the PostgreSQL database to provide a convenient way for users to create databases, create tables, alter tables and query their own data using industry-standard SQL.

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. [1]

Features

  • Administer multiple servers
  • Support for PostgreSQL 7.4.x, 8.0.x, 8.1.x, 8.2.x, 8.3.x, 8.4.x, 9.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
  • Supports the Slony master-slave replication engine
  • Excellent language support:

* Available in 27 languages

* No encoding conflicts. Edit Russian data using a Japanese interface!

  • Easy to install and configure

See also

References

  1. ^ phpPgAdmin Project (2008-04-25). "About phpPgAdmin". Retrieved 2008-04-25.