↑↓ select ↵ open ⌫ change scope Open full search

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

System Catalogs / System views

pg_file_settings

Read the PG 18 manual

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

Reading PG 18current·documented in 13 of 24 versions, 9.5 to 20

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

Columns 7

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
sourcefiletextFull path name of the configuration file
sourcelineint4Line number within the configuration file where the entry appears
seqnoint4Order in which the entries are processed (1..n)
nametextConfiguration parameter name
settingtextValue to be assigned to the parameter
appliedboolTrue if the value can be applied successfully
errortextIf not null, an error message indicating why this entry could not be applied
Column history across versions
Version history 3
  1. 9.6 → 10 reworded
  2. 9.5 → 9.6 reworded
  3. 9.4 → 9.5 added

Definition snapshot: english-manuals:ee48347897d948ce97aba9a8055… · English manual source