The pg_config view exposes the compile-time configuration parameters of the currently installed database version. It is primarily used by software packages that need to interface with the database to locate the required header files and libraries. The view returns the same information as the pg_config client application.
Note
By default, only privileged accounts can read the pg_config view.
Columns
| Column | Type | Description |
|---|---|---|
name | text | The name of the parameter |
setting | text | The value of the parameter |
Query the view
Run the following statement to retrieve all compile-time parameters:
SELECT * FROM pg_config;