phpPgAdmin

phpPgAdmin

Screenshot  phpPgAdmin Export Screen
Stable release	5.1 / April 15, 2013
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

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

See also

• phpMyAdmin

References

1. "About phpPgAdmin". phpPgAdmin Project. 2008-04-25. Retrieved 2015-09-21.

External links

• Official website
• phppgadmin on GitHub