phpPgAdmin

From Wikipedia, the free encyclopedia
Jump to: navigation, search
phpPgAdmin
Stable release 5.1 / April 15, 2013 (2013-04-15)
Written in PHP and JavaScript
Operating system Cross-platform
Type Web Database Management
License GNU General Public License
Website 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[edit]

PhPgAdmin has, among others, the following 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, 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

See also[edit]

References[edit]

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

External links[edit]