This section explains how you can use pgAdmin III to maintain your PostgreSQL databases. PgAdmin III supports database server versions 7.3 and up. Versions older than 7.3 are not supported, please use pgAdmin II for these.
The main window shows the structure of the database, and all details of the objects in it.
Use the Add server.. menu or toolbar button to add a new database connection to pgAdmin III.
With Change password you can change the password of the user you're currently connected with on the selected database.
The Query Tool allows the execution of arbitrary sql commands.
The Export Tool allows the exporting of data from the Query Tool.
The Edit Grid allows viewing and editing of data in a selected table or view.
The Maintenance tool executes the task of rebuilding statistics on databases and tables, and cleans up unused data.
The Server status window will show the currently connected users of the selected database server.
The Options dialogue will allow you to configure pgAdmin III.
When editing the properties of a database object, pgAdmin III will support you with help about the underlying PostgreSQL SQL commands, if you press the F1 function key. In order for this to work, the sql helpsite setting in the options dialog must be set correctly.