↑↓ select ↵ open ⌫ change scope Open full search

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

SYSTEM CATALOGS / SYSTEM VIEWS

pg_ident_file_mappings

Read PG 18 manual ↗

The view pg_ident_file_mappings provides a summary of the contents of the client user name mapping configuration file, pg_ident.conf.

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

Columns 7

ColumnTypeDescription / reference
map_numberint4Number of this map, in priority order, if valid, otherwise NULL
file_nametextName of the file containing this map
line_numberint4Line number of this map in file_name
map_nametextName of the map
sys_nametextDetected user name of the client
pg_usernametextRequested PostgreSQL user name
errortextIf not NULL, an error message indicating why this line could not be processed
Column history across versions
Column9.09.19.29.39.49.59.61011121314151617181920
line_number············●●●●●●
map_name············●●●●●●
sys_name············●●●●●●
pg_username············●●●●●●
error············●●●●●●
map_number·············●●●●●
file_name·············●●●●●
Version history 2
  1. PG 15 → 16changed
  2. PG 14 → 15added

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