PostgreSQL-related tools

Pentaho Data Integration (kettle): A great tool for extracting, converting, loading (Extract Transform and Load,etl)

Pentaho report Server: A powerful reporting engine

PgAdmin3: An excellent database management tool

Php5-postgresql: A package for PHP for local access to PostgreSQL

QCubed: A PHP development framework that supports PostgreSQL

Yii: A good PHP development framework

Talend: A very useful ETL tool

BIRT: A good Java reporting tool with a simple report creation environment

Psycopg2:python Kit for PostgreSQL

Datagrip: A database IDE tool, known as the Swiss Army Knife of the database, https://www.jetbrains.com/datagrip/

(Registration method: Select License server at the time of registration, fill http://idea.lanyus.com, then click OK)

Http://www.sql-info.de/postgresql/postgres-gotchas.html

Http://www.sql-info.de/mysql/gotchas.html

PostgreSQL-related tools