pgAdmin
| PgAdmin
|
|
|---|---|
|
|
 Screenshot with query window |
|
| Basic data
|
|
| developer | pgAdmin Development Team |
| Current version |
4.10 ( July 4, 2019 ) |
| operating system | Unix derivatives , Linux , Windows |
| programming language | C ++ |
| category | Database management tools , integrated development environment |
| License | PostgreSQL license |
| German speaking | Yes |
| www.pgadmin.org | |
pgAdmin is an open source software for the development and administration of PostgreSQL databases and derived databases such as EnterpriseDB Postgres Plus Advanced Server or Greenplum . A graphical user interface facilitates the administration of databases. The editor for SQL queries contains a graphical EXPLAIN which can be used to create higher-performance queries. With a native connection to PostgreSQL, the GUI enables access to the entire PostgreSQL functionality.
The software is offered in versions for the Linux , Mac OS X , FreeBSD , Solaris and Windows operating systems .
Examples
Create a function in the SQL window
Query window with a graphic representation of the EXPLAIN
Overview of the objects with source code
development
pgAdmin is an open source project. Further development is currently being coordinated by Dave Page, a senior software architect at EnterpriseDB. The software is also the basis for EnterpriseDB's management tools. With this extension, an unlimited number of servers can be controlled simultaneously. pgAdmin is programmed in Python and jQuery with Bootstrap, using the Flask Framework .
Another PHP- based administration tool for PostgreSQL is phpPgAdmin .
Web links
- Official project homepage. Retrieved January 20, 2015 .
- "Dave's Postgres Blog" - Dave Page's blog. Retrieved January 20, 2015 .
- pgAdmin4 (September 2016)
- pgadmin4 Git repository
Individual evidence
- ↑ www.pgadmin.org .
- ↑ PostgreSQL: License (English) - page at PostgreSQL.org ; Status: Jan. 20, 2015
- ↑ Development team. Retrieved January 20, 2015 .
- ↑ EnterpriseDB. Retrieved August 28, 2020 .