pgAdmin 1.8 online documentation
This section explains how you can use pgAdmin to maintain your
PostgreSQL databases. pgAdmin 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.
With Change password you can
change the password of the user you're currently connected with on
the selected database.
Control server allows you
to control the status of database servers, start and stop them.
The Query Tool allows the execution
of arbitrary sql commands.
The Debugger allows the debugging
of pl/pgsql and edb-spl functions and stored procedures.
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, cleans up
unused data and reorganizes indexes.
The Backup tool calls the
PostgreSQL dump tool to create backup files of your data.
The Restore tool calls the
PostgreSQL restore tool to restore data from backup files.
The Grant Wizard allows
assignment of group or user privileges on many objects at a
The Report Tool generates
simple reports from data and objects within your databases.
The Server status window will show
the currently connected users, locks and the server log of the selected database server.
The Options dialogue will allow
you to configure pgAdmin.
Guru Hints help you perfect your databases.
Command Line Options to start pgAdmin in the most convenient mode.
When editing the properties of a database object, pgAdmin 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.