Web pgadmin.org


A data grid allows to insert, modify and drop data easily. The data is retrieved on-demand when it needs to be displayed. This allows the user to browse very large tables quickly and efficiently.

The data grid

A query tool with colour syntax highlighting allows users to run custom queries. The SQL definition of any object can be automatically transfered to the query tool from the object browser, or the user can author simple queries or complex scripts by hand. Long running queries can be cancelled if required by clicking on the red square button. The tool displays execution times of queries to help the user optimise them, and fully supports PostgreSQL's asynchronous notification system.

The query tool

EXPLAIN and/or ANALYZE your queries to take advantage of PostgreSQL unique optimisation features. You will soon realise that PostgreSQL is amongst the fastest enterprise class databases available.

The graphical EXPLAIN tool