Online Documentation for SQL Manager for PostgreSQL

Viewing Parameters

The Parameter List tab of the Server Configuration manager allows you to view current parameters of your PostgreSQL. It displays a number of configuration parameters that affect the behavior of the database system. To obtain more information on specific parameters, refer to PostgreSQL documentation.


Note: If you are not connected to the database server yet, select the host from the drop-down list on the Navigation bar to define connection settings.


Server Configuration - Viewing Parameters



The Parameter List displays the parameters as a grid with the following columns: Parameter Name, Value, Short Description, Extra Description, Context, Type, Source, Minimum, Maximum, Parameter Group. If more convenient, you can change the order of the columns by dragging their headers horizontally.


Click a column caption to sort items by values of this column in the ascending or the descending mode.


Note: Only parameters with "user" or "superuser" values of the Context field can be redefined.


If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.


Right-click an item within the list to call the context menu allowing you to refresh the list.