pgAdmin 1.14 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
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
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 time.
The Report Tool generates simple reports
from data and objects within your databases.
The Server status window will show the
currently connected users, locks, prepared transactions and the server
log of the selected database server.
The Options dialogue will allow you to
Guru Hints help you perfect your
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.