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.
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 before closing properties with unsaved changes switch is set to True,
pgAdmin will warn you before closing the properties dialog of an object if there
are any unsaved changes. On user confirmation, the properties dialog will close.
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 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 Lock layout field to lock the UI layout at different levels. This
can also be changed from File menu on the menu bar
Option |
Action |
None |
No locking. Every panel is resizable and dockable. |
Prevent docking |
This will disable the docking/undocking of the panels |
Full |
This will disable resizing, docking/undocking of the panels |
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.
Use the fields on the Keyboard shortcuts panel to configure shortcuts for the
main window navigation:
Use the fields on the Nodes panel to select the object types that will be
displayed in the Browser tree control:
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.
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 Themes drop-down listbox to select the theme for pgAdmin. You’ll also get a preview just below the
drop down. Note that, to apply the theme you need to refresh the pgAdmin page. You can also submit your
own themes, check here how.
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.
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.