PhpPgAdmin
Encyclopedia
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.
Web application
A web application is an application that is accessed over a network such as the Internet or an intranet. The term may also mean a computer software application that is coded in a browser-supported language and reliant on a common web browser to render the application executable.Web applications are...
, written in PHP
PHP
PHP is a general-purpose server-side scripting language originally designed for web development to produce dynamic web pages. For this purpose, PHP code is embedded into the HTML source document and interpreted by a web server with a PHP processor module, which generates the web page document...
, for managing PostgreSQL
PostgreSQL
PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
databases.
phpPgAdmin is a web-based client which leverages PHP scripting and the PostgreSQL
PostgreSQL
PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...
database to provide a convenient way for users to create databases, create tables, alter tables and query their own data using industry-standard SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
.
The project originally started as a fork of phpMyAdmin
PhpMyAdmin
phpMyAdmin is an open source tool written in PHP intended to handle the administration of MySQL with the use of a Web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and...
, 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.
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