Preferences Dialog
Use options on the Preferences dialog to customize the behavior of the client.
To open the Preferences dialog, select Preferences from the File menu.
The left pane of the Preferences dialog displays a tree control; each node of
the tree control provides access to options that are related to the node under
which they are displayed.
- Use the plus sign (+) to the left of a node name to expand a segment of the
tree control.
- Use the minus sign (-) to the left of a node name to close that node.
The Browser Node
Use preferences found in the Browser node of the tree control to personalize
your workspace.
Use the fields on the Display panel to specify general display preferences:
- When the Auto-expand sole children switch is set to True, child nodes will
be automatically expanded if a treeview node is expanded and has only a single
child.
- Use the Browser tree state saving interval field to set the treeview state
saving interval. A value of -1 will disable the treeview state saving
functionality.
- When the Confirm on close or refresh switch is set to True, pgAdmin will
attempt to catch browser close or refresh events and prompt before allowing
them to continue.
- When the Show system objects? switch is set to True, the client will
display system objects such as system schemas (for example, pg_temp) or
system columns (for example, xmin or ctid) in the tree control.
- When the Enable browser tree animation? switch is set to True, the client
will display the animated tree control otherwise it will be unanimated.
- When the Enable dialogue/notification animation? switch is set to True,
the client will display the animated dialogues/notifications otherwise it
will be unanimated.
Use the fields on the Keyboard shortcuts panel to configure shortcuts for the
main window navigation:
- The panel displays a list of keyboard shortcuts available for the main window;
select the combination of the modifier keys along with the key to configure
each shortcut.
Use the fields on the Nodes panel to select the object types that will be
displayed in the Browser tree control:
- The panel displays a list of database objects; slide the switch located next
to each object to Show or Hide the database object. When querying system
catalogs, you can reduce the number of object types displayed to increase
speed.
Use fields on the Properties panel to specify browser properties:
- Include a value in the Count rows if estimated less than field to perform a
SELECT count(*) if the estimated number of rows in a table (as read from the
table statistics) is below the specified limit. After performing the SELECT
count(*), pgAdmin will display the row count. The default is 2000.
- Provide a value in the Maximum job history rows field to limit the number of
rows to show on the statistics tab for pgAgent jobs. The default is 250.
The Dashboards Node
Expand the Dashboards node to specify your dashboard display preferences.
Use the fields on the Graphs panel to specify your display preferences for
the graphs on the Dashboard tab:
- Use the Block I/O statistics refresh rate field to specify the number of
seconds between block I/O statistic samples displayed in graphs.
- Use the Session statistics refresh rate field to specify the number of
seconds between session statistic samples displayed in graphs.
- Use the Transaction throughput refresh rate field to specify the number of
seconds between transaction throughput samples displayed in graphs.
- Use the Tuples in refresh rate field to specify the number of seconds
between tuples-in samples displayed in graphs.
- Use the Tuples out refresh rate field to specify the number of seconds
between tuples-out samples displayed in graphs.
- When the Show activity? switch is set to True, activity tables will be
displayed on dashboards.
- When the Show graph data points? switch is set to True, data points will
be visible on graph lines.
- When the Show graphs? switch is set to True, graphs will be displayed on
dashboards.
- When the Show mouse hover tooltip? switch is set to True, a tooltip will
appear on mouse hover on the graph lines giving the data point details.
The Debugger Node
Expand the Debugger node to specify your debugger display preferences.
- When the Open in new browser tab switch is set to True, the Debugger will
open in a new browser tab when invoked.
Use the fields on the Keyboard shortcuts panel to configure shortcuts for the
debugger window navigation:
The Miscellaneous Node
Expand the Miscellaneous node to specify miscellaneous display preferences.
- Use the User language drop-down listbox to select the display language for
the client.
The Paths Node
Expand the Paths node to specify the locations of supporting utility and help
files.
Use the fields on the Binary paths panel to specify the path to the directory
that contains the utility programs (pg_dump, pg_restore, and pg_dumpall) for
monitored databases:
Use the EDB Advanced Server Binary Path field to specify the location of the
EDB Postgres Advanced Server utility programs. If this path is not set,
pgAdmin will attempt to find the utilities in standard locations used by
EnterpriseDB.
Use the Greenplum Database Binary Path field to specify the location of the
Greenplum database utility programs. If this path is not set, pgAdmin will
attempt to find the utilities in standard locations used by Greenplum.
- Use the PostgreSQL Binary Path field to specify the location of the
PostgreSQL utility programs. If this path is not set, pgAdmin will attempt
to find the utilities in standard locations used by PostgreSQL.
Use the fields on the Help panel to specify the location of help files.
- Use the EDB Advanced Server Help Path to specify the path to EDB Postgres
Advanced Server documentation.
- Use the PostgreSQL Help Path to specify the path to PostgreSQL
documentation.
Please note: the default help paths include the VERSION placeholder; the
$VERSION$ placeholder will be replaced by the current database version.
The Storage Node
Expand the Storage node to specify your storage preferences.
Use the fields on the Options panel to specify storage preferences.
- Use the File dialog view drop-down listbox to select the style of icons and
display format that will be displayed when you open the file manager; select
List to display a list view, or Grid to display folder icons.
- Use the Last directory visited field to specify the name of the folder in
which the file manager will open.
- Use the Maximum file upload size(MB) field on the Options panel of the
Storage node to specify the maximum file size for an upload.
- When the Show hidden files and folders? switch is set to True, the file
manager will display hidden files and folders.