System Catalogs / System views
pg_hba_file_rules
Read the PG 18 manualThe view pg_hba_file_rules provides a summary of the contents of the client authentication configuration file, pg_hba.conf.
Reading PG 18current·documented in 11 of 24 versions, 10 to 20
- Kind
- System views
- Columns in this snapshot
- 11
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 11
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
rule_number | int4 | Number of this rule, if valid, otherwise NULL. This indicates the order in which each rule is considered until a match is found during authentication. |
file_name | text | Name of the file containing this rule |
line_number | int4 | Line number of this rule in file_name |
type | text | Type of connection |
database | text[] | List of database name(s) to which this rule applies |
user_name | text[] | List of user and group name(s) to which this rule applies |
address | text | Host name or IP address, or one of all, samehost, or samenet, or null for local connections |
netmask | text | IP address mask, or null if not applicable |
auth_method | text | Authentication method |
options | text[] | Options specified for authentication method, if any |
error | text | If not null, an error message indicating why this line could not be processed |
Column history across versions
Definition snapshot: english-manuals:c574d4053d527ea1c34ad31da3a… · English manual source