Ask a Question
Report a Bug
This page in other versions:
This document in other formats:
The left pane of the main window displays a tree control (the pgAdmin tree
control) that provides access to the objects that reside on a server.
You can expand nodes in the tree control to view the database objects that
reside on a selected server. The tree control expands to display a hierarchical
Use the plus sign (+) to the left of a node to expand a segment of the tree
Click the minus sign (-) to the left of a node to close that node.
You can also drag and drop certain objects to the Query Tool which
can save time in typing long object names. Text containing the object name will be
fully qualified with schema. Double quotes will be added if required.
For functions and procedures, the function name along with parameter names will
be pasted in the Query Tool.
Access context-sensitive menus by right-clicking on a node of the tree control
to perform common tasks. Menus display options that include one or more of the
following selections (options appear in alphabetical order):
Add named restore point
Click to create and enter the name of a restore point.
Click to open the Backup… dialog to backup database objects.
Click to open the Backup Globals… dialog to backup cluster objects.
Click to open the Backup Server… dialog to backup a server.
Click to open the Connect to Server dialog to establish a connection with a server.
Click to access a context menu that provides context-sensitive selections.
Your selection opens a Create dialog for creating a new object.
Click to open the Query tool to edit or view the CREATE script.
Click through to open the Debug tool or to select Set breakpoint to stop or pause a script execution.
Click to delete the currently selected object from the server.
Click to terminate a database connection.
Click to refresh the currently selected object.
Click to delete the currently selected object and all dependent objects from the server.
Click to access the Debugger tool.
Click to access the Grant Wizard tool.
Click to open the Maintenance… dialog to VACUUM, ANALYZE, REINDEX, or CLUSTER.
Click to review or modify the currently selected object’s properties.
Click to update configuration files without restarting the server.
Click to access the Restore dialog to restore database files from a backup.
Use the View Data option to access the data stored in a selected table with the Data Output tab of the Query Tool.
The context-sensitive menus associated with Tables and nested Table nodes provides additional display options (options appear in alphabetical order):
Click open the Import/Export… dialog to import data to or export data from the selected table.
Click to reset statistics for the selected table.
Click to open the Query tool to edit or view the selected script from the flyout menu.
Click to remove all rows from a table.
Click to remove all rows from a table and its child tables.
View First 100 Rows
Click to access a data grid that displays the first 100 rows of the selected table.
View Last 100 Rows
Click to access a data grid that displays the last 100 rows of the selected table.
View All Rows
Click to access a a data grid that displays all rows of the selected table.
View Filtered Rows…
Click to access the Data Filter popup to apply a filter to a set of data.