pg_ident_file_mappings
The view pg_ident_file_mappings provides a summary of the contents of the client user name mapping configuration file, pg_ident.conf. A row appears in this view for each non-empty, non-comment line in the file, with annotations indicating whether the map could be applied successfully. This view can be helpful for checking whether planned changes in the authentication configuration file will work, or for diagnosing a previous failure. Note that this view reports on the current contents of the file, not on what was last loaded by the server. By default, the pg_ident_file_mappings view can be read only by superusers.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- view
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- map_number, file_name, line_number, map_name, sys_name, pg_username, error
- runtime verified
- false
- source
- english-manual
Definition PG 18
The view pg_ident_file_mappings provides a summary of the contents of the client user name mapping configuration file, pg_ident.conf. A row appears in this view for each non-empty, non-comment line in the file, with annotations indicating whether the map could be applied successfully. This view can be helpful for checking whether planned changes in the authentication configuration file will work, or for diagnosing a previous failure. Note that this view reports on the current contents of the file, not on what was last loaded by the server. By default, the pg_ident_file_mappings view can be read only by superusers.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| map_number | int4 | Nullable | Number of this map, in priority order, if valid, otherwise NULL |
| file_name | text | Nullable | Name of the file containing this map |
| line_number | int4 | Nullable | Line number of this map in file_name |
| map_name | text | Nullable | Name of the map |
| sys_name | text | Nullable | Detected user name of the client |
| pg_username | text | Nullable | Requested PostgreSQL user name |
| error | text | Nullable | If not NULL, an error message indicating why this line could not be processed |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:871b7a1991d6cc089944d8a277a2da1cb83e3dd46d2f6132ea552d9f21f5f30a
Text language: en · catalog-bilingual-repair:871b7a1991d6cc089944d8a277a2da1cb83e3dd46d2f6132ea552d9f21f5f30a