Web pgadmin.org

User interface

The pgAdmin project started in 1997 and the application is used by tens of thousands of users worldwide. With the help and suggestions of those users, we have been constantly improving the usability of pgAdmin.

pgAdmin can connect to any PostgreSQL 7.3/7.4 and 8.x database using the embedded libpq native library. The application does not need any ODBC, .NET or JDBC layer. When configured server-side, it is possible to connect using encrypted password or SSL authentication.

The database connection dialogue

The properties and statistics of the selected object are displayed in the right pane of pgAdmin. Notice the display of the SQL definition with colour syntax highlighting.

As objects are created and modified, pgAdmin will show the user the code used to make the modifications, as well as the reverse-engineered SQL definition of the selected object. This helps the user learn and understand the SQL easily allowing them to work productively in the GUI and the command line or in scripts.

The properties of the selected object.

A double-click in the navigation tree opens the selected object in a separate dialogue, or the user may opt to create a new object. Notice the tabs giving access to Properties, Parameters, Security and the SQL used to create the object.

The function properties dialogue

pgAdmin includes a table editor. Columns can be dropped. Column data types can be modified in certain conditions as allowed by the server version.

The table properties dialogue