Article - CS226826
PostgreSQL Tool Triage
Modified: 22-Jan-2016
Applies To
- ThingWorx Platform 6.5
Description
psql terminal:
The psql client is a command-line client distributed with PostgreSQL, often called as interactive terminal. Psql is a simple yet powerful tool with which you can directly interface with the PostgreSQL server. The psql client comes default with the PostgreSQL database.
Key features:
pgAdmin III:
pgAdmin III is an open source administration and development tool for PostgreSQL database. It delivers the needs of both admin and normal users from writing simple SQL queries to developing complex databases.
Key features:
phpPgAdmin:
phpPgAdmin is a web-based client for managing PostgreSQL databases. It provides the user with a convenient way to create databases, create tables, alter tables and query the data using SQL.
Key features:
TeamPostgreSQL:
TeamPostgreSQL is a browser-based tool for PostgreSQL administration. Using TeamPostgreSQL, database objects can be accessed from anywhere in the web browser.
Key features:
pgBadger is a PostgreSQL log analyzer for generating reports from the PostgreSQL log files. It is built in Perl language and uses a javascript
The psql client is a command-line client distributed with PostgreSQL, often called as interactive terminal. Psql is a simple yet powerful tool with which you can directly interface with the PostgreSQL server. The psql client comes default with the PostgreSQL database.
Key features:
- Issue queries either through commands or from a file
- Provides shell-like features to automate tasks
For more information, refer http://www.postgresql.org/docs/9.5/static/app-psql.html
pgAdmin III:
pgAdmin III is an open source administration and development tool for PostgreSQL database. It delivers the needs of both admin and normal users from writing simple SQL queries to developing complex databases.
Key features:
- Open source
- Supports all OS platforms
- Provides Graphical User Interface (GUI)
- No additional drivers are required
- Supports more than 30 different languages
phpPgAdmin:
phpPgAdmin is a web-based client for managing PostgreSQL databases. It provides the user with a convenient way to create databases, create tables, alter tables and query the data using SQL.
Key features:
- Open source and supports PostgreSQL 9.x
- Requires webserver
- Administer multiple servers
- Supports the slony master-slave replication engine
TeamPostgreSQL:
TeamPostgreSQL is a browser-based tool for PostgreSQL administration. Using TeamPostgreSQL, database objects can be accessed from anywhere in the web browser.
Key features:
- Open source and cross-platform support
- Supports SSH for both the web interface and the database connections
- GUI with tabbed SQL editors
Monitoring Tools
pgBadger:pgBadger is a PostgreSQL log analyzer for generating reports from the PostgreSQL log files. It is built in Perl language and uses a javascript
This is a printer-friendly version of Article 226826 and may be out of date. For the latest version click CS226826