pg_ident_file_mappings 是一个 系统目录 视图,它提供了 `pg_ident.conf` 文件内容的摘要。
pg_ident_file_mappings 在 PostgreSQL 15 中添加。
按 PostgreSQL 版本定义
pg_ident_file_mappings (PostgreSQL 19)
View "pg_catalog.pg_ident_file_mappings"
Column | Type | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
map_number | integer | | |
file_name | text | | |
line_number | integer | | |
map_name | text | | |
sys_name | text | | |
pg_username | text | | |
error | text | | |
pg_ident_file_mappings (PostgreSQL 18)
View "pg_catalog.pg_ident_file_mappings"
Column | Type | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
map_number | integer | | |
file_name | text | | |
line_number | integer | | |
map_name | text | | |
sys_name | text | | |
pg_username | text | | |
error | text | | |
pg_ident_file_mappings (PostgreSQL 17)
View "pg_catalog.pg_ident_file_mappings"
Column | Type | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
map_number | integer | | |
file_name | text | | |
line_number | integer | | |
map_name | text | | |
sys_name | text | | |
pg_username | text | | |
error | text | | |
pg_ident_file_mappings (PostgreSQL 16)
View "pg_catalog.pg_ident_file_mappings"
Column | Type | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
map_number | integer | | |
file_name | text | | |
line_number | integer | | |
map_name | text | | |
sys_name | text | | |
pg_username | text | | |
error | text | | |
pg_ident_file_mappings (PostgreSQL 15)
View "pg_catalog.pg_ident_file_mappings"
Column | Type | Collation | Nullable | Default
-------------+---------+-----------+----------+---------
line_number | integer | | |
map_name | text | | |
sys_name | text | | |
pg_username | text | | |
error | text | | |
变更历史
- PostgreSQL 15
- 添加(提交 a2c84990)
参考资料
- PostgreSQL 文档: pg_ident_file_mappings
另请参阅
pg_ident.conf, ident_conf, pg_hba_file_rules
