Ask a Question
Report a Bug
This page in other versions:
In the main window, the structure of the databases is displayed.
You can create new objects, delete and edit existing objects if the
privileges of the user that you are using on the current connection
to the database allow this.
The left side of the main window shows a tree with all servers,
and the objects they contain.
The upper right side shows details of the object currently
selected in the tree. Some objects might have statistics in addition
to their properties, these can be shown if you select the Statistics
The lower right side contains a reverse engineered SQL script. You
can copy this to any editor using cut & paste, or save it to a file
using Save definition… from the File menu, or use it as a template
if you select the Query Tool. If the
Copy SQL from main window to query tool option is selected, the SQL
query will be copied automatically to the tool.
The status line will show you some status information, as well as
the time the last action took pgAdmin III to complete.
You can resize the main window, and change the sizes of the three
main regions as you prefer. These adjustments will be preserved when
you exit the program.
pgAdmin is bandwidth friendly. The status of objects in the browser
is only refreshed on request or after changes made with the built-in tools.
Be aware that this does not cover changes made via manual SQL or from other
users or other clients. It is generally advisable to manually refresh
objects before working on them in such environments.
After you have added the desired server(s) to the tree on the left
side using the Add server menu or toolbar
button, each server will show up under the top node “Servers”.
To open a connection to a server, select the desired server in the
tree, and double click on it or use Connect from the Tools menu. The
connection will be established, and the properties of the top level
objects are retrieved from the database server. If you’ve been
connected to that database previously, pgAdmin III will restore the
previous selection of database and schema for you. The current
situation is saved when exiting the program, so that pgAdmin III is
able to restore the previous environment.
Using the menu or toolbar buttons, you can create new objects,
delete objects and edit properties of existing objects if the user
that you entered when adding the server connection has sufficient
privileges. You may find some options grayed out if displaying
properties. This means, that the database server you’re currently
using doesn’t support the feature, or that this property can’t be
changed by design, or that your user privileges won’t allow you to
You can search for objects in the database using the Search Tool