Jump to content

phpPgAdmin

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Modernponderer (talk | contribs) at 21:03, 25 January 2017 (restore features section from earlier revision). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.


phpPgAdmin
Developer(s)phpPgAdmin-Community
Stable release
5.1 / April 14, 2013; 12 years ago (2013-04-14)[1]
Repository
Written inPHP
Operating systemCross-platform
Available inMultilingual (27)
TypeWeb database management
LicenseGNU General Public License 2 or later[2]
Websitehttp://phppgadmin.sourceforge.net/doku.php?id=start

phpPgAdmin is a fully functional web-based administration utility for a PostgreSQL database server,[3] licensed under a free and open source license. Similar to phpMyAdmin, of which phpPgAdmin is also based on,[4] it is written in PHP and can be accessed with a web browser. PhpPgAdmin requires a web server with PHP[5], such as Apache or Nginx, and is therefore cross-platform[6].

History

The history of phpPgAdmin can be found on their about page:[4]

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,[1] is maintained by The phpPgAdmin Project.

References

  1. ^ a b "phpPgAdmin - start". phpPgAdmin. phpPgAdmin-Community. 2013-04-15. Retrieved 2017-01-02.
  2. ^ "phpPgAdmin License". Github. phpPgAdmin-Community. 2017-01-02. Retrieved 2017-01-02.
  3. ^ "phpPgAdmin download - SourceForge.net". SourceForge. phpPgAdmin-Community. 2013-06-11. Retrieved 2017-01-02.
  4. ^ a b "phpPgAdmin - about". phpPgAdmin. phpPgAdmin-Community. 2011-02-28. Retrieved 2017-01-02.
  5. ^ "phpPgAdmin - ArchWiki". wiki.archlinux.org. Arch community. 2015-12-28. Retrieved 2017-01-24.
  6. ^ Robert Treat (2006-04-01). "Running PostgreSQL in a cross-platform environment". TechTarget. Retrieved 2017-01-24.