pgAdmin 1.4 online documentation

Using pgAdmin

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 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 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.

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.