{"Entry":{"collection":"catalog","key":"pg_ident_file_mappings","name":"pg_ident_file_mappings","aliases":[],"metadata":{"changed_in":["16"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"14","order":false,"removed":[],"status":"added","to":"15","types":[]},{"added":["map_number","file_name"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Line number of this map in pg_ident.conf","name":"line_number","to":"Line number of this map in file_name"}],"from":"15","listing":[],"order":false,"removed":[],"status":"changed","to":"16","types":[],"unlisted":[]}],"column_count":7,"content_hash":"74957607a247018f6390ce5c9ba2fa1102ff951e08d8d31dda2690a65ca3cdf8","first_version":"15","imported_at":"2026-09-30T00:40:55.559867+08:00","kind":"view","last_version":"20","name":"pg_ident_file_mappings","position":35,"present_in":["15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:38c79b369d537eddefba66fcfc4464d24ef8bcf4d728feb2f613b5f32b748820","summary":"The view pg_ident_file_mappings provides a summary of the contents of the client user name mapping configuration file, pg_ident.conf.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_ident_file_mappings","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_ident_file_mappings","SourceRevision":"english-manuals:38c79b369d537eddefba66fcfc4464d24ef8bcf4d728feb2f613b5f32b748820","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"Number of this map, in priority order, if valid, otherwise NULL","description_zh":"","documented":true,"documented_name":"map_number","hidden":false,"name":"map_number","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":2,"description":"Name of the file containing this map","description_zh":"","documented":true,"documented_name":"file_name","hidden":false,"name":"file_name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":3,"description":"Line number of this map in file_name","description_zh":"","documented":true,"documented_name":"line_number","hidden":false,"name":"line_number","not_null":false,"references":"","type":"int4","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":4,"description":"Name of the map","description_zh":"","documented":true,"documented_name":"map_name","hidden":false,"name":"map_name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":5,"description":"Detected user name of the client","description_zh":"","documented":true,"documented_name":"sys_name","hidden":false,"name":"sys_name","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":6,"description":"Requested PostgreSQL user name","description_zh":"","documented":true,"documented_name":"pg_username","hidden":false,"name":"pg_username","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":7,"description":"If not NULL, an error message indicating why this line could not be processed","description_zh":"","documented":true,"documented_name":"error","hidden":false,"name":"error","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25}],"description":"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.\n\nThis 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.\n\nBy default, the pg_ident_file_mappings view can be read only by superusers.","description_zh":"","doc":{"anchor":"id-1.10.5.15.6","file":"view-pg-ident-file-mappings.html","lang":"en","sha256":"a7ef516cddd151bed43b7e5d9febcb7898671670b70ca8844ea2d10fb5f7a922","slug":"18"},"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"},"ManualEvidence":{"doc":{"anchor":"id-1.10.5.15.6","file":"view-pg-ident-file-mappings.html","lang":"en","sha256":"a7ef516cddd151bed43b7e5d9febcb7898671670b70ca8844ea2d10fb5f7a922","slug":"18"}},"MeasuredEvidence":{"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}},"Text":{"Collection":"catalog","Key":"pg_ident_file_mappings","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_ident_file_mappings","Summary":"视图pg_ident_file_mappings提供客户端用户名映射配置文件 pg_ident.conf内容的摘要。文件中每个非空且非注释的行都会在该视图中显示一行，并带有注解，说明该映射是否能成功应用。\n\n该视图有助于检查认证配置文件中的计划变更是否可行，或诊断先前的失败。请注意，该视图报告的是文件的当前内容，而不是服务器上次加载的内容。\n\n默认情况下，pg_ident_file_mappings 视图只能由超级用户读取。","BodyHTML":"\u003cp\u003e视图pg_ident_file_mappings提供客户端用户名映射配置文件 pg_ident.conf内容的摘要。文件中每个非空且非注释的行都会在该视图中显示一行，并带有注解，说明该映射是否能成功应用。\n\n该视图有助于检查认证配置文件中的计划变更是否可行，或诊断先前的失败。请注意，该视图报告的是文件的当前内容，而不是服务器上次加载的内容。\n\n默认情况下，pg_ident_file_mappings 视图只能由超级用户读取。\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"9369ae248d64548aca59cec012e5cf37b2998f14c1d99eeab8ba4cd74ad63c89","Payload":{"columns":[{"description_zh":"如果该映射有效，则为其编号，按优先级顺序排列；否则为 NULL","name":"map_number","type":"integer","zh_from":"doc"},{"description_zh":"包含该映射的文件名","name":"file_name","type":"text","zh_from":"doc"},{"description_zh":"该映射在 file_name 中的行号","name":"line_number","type":"integer","zh_from":"doc"},{"description_zh":"映射名称","name":"map_name","type":"text","zh_from":"doc"},{"description_zh":"检测到的客户端用户名","name":"sys_name","type":"text","zh_from":"doc"},{"description_zh":"请求的PostgreSQL用户名","name":"pg_username","type":"text","zh_from":"doc"},{"description_zh":"如果不是 NULL，则为说明为什么该行无法处理的错误消息","name":"error","type":"text","zh_from":"doc"}],"description_zh":"视图pg_ident_file_mappings提供客户端用户名映射配置文件 pg_ident.conf内容的摘要。文件中每个非空且非注释的行都会在该视图中显示一行，并带有注解，说明该映射是否能成功应用。\n\n该视图有助于检查认证配置文件中的计划变更是否可行，或诊断先前的失败。请注意，该视图报告的是文件的当前内容，而不是服务器上次加载的内容。\n\n默认情况下，pg_ident_file_mappings 视图只能由超级用户读取。","zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}