PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM VIEWS

pg_file_settings

Read PG 18 manual ↗

The view pg_file_settings provides a summary of the contents of the server's configuration file(s).

Kind: System views
Columns in this snapshot: 7
Definition source: English manual

Columns 7

Column	Type	Description / reference
`sourcefile`	`text`	Full path name of the configuration file
`sourceline`	`int4`	Line number within the configuration file where the entry appears
`seqno`	`int4`	Order in which the entries are processed (1..n)
`name`	`text`	Configuration parameter name
`setting`	`text`	Value to be assigned to the parameter
`applied`	`bool`	True if the value can be applied successfully
`error`	`text`	If not null, an error message indicating why this entry could not be applied

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`sourcefile`	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●
`sourceline`	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●
`seqno`	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●
`name`	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●
`setting`	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●
`applied`	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●
`error`	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 3

Definition snapshot: english-manuals:1eb98429bc1a83acc879859d9e4… · English manual source