[PATCH] Add inline comments to the pg_hba_file_rules view
| От | Jim Jones |
|---|---|
| Тема | [PATCH] Add inline comments to the pg_hba_file_rules view |
| Дата | |
| Msg-id | 4d623899-36ac-71b5-311d-2a4672d75736@uni-muenster.de обсуждение исходный текст |
| Ответы |
Re: [PATCH] Add inline comments to the pg_hba_file_rules view
Re: [PATCH] Add inline comments to the pg_hba_file_rules view Re: [PATCH] Add inline comments to the pg_hba_file_rules view Re: [PATCH] Add inline comments to the pg_hba_file_rules view |
| Список | pgsql-hackers |
Hi,
This patch proposes the column "comment" to the pg_hba_file_rules view.
It basically parses the inline comment (if any) of a valid pg_hba.conf
entry and displays it in the new column.
For such pg_hba entries ...
host db jim 127.0.0.1/32 md5 # foo
host db jim 127.0.0.1/32 md5 #bar
host db jim 127.0.0.1/32 md5 # #foo#
... it returns the following pg_hba_file_rules records:
postgres=# SELECT type, database, user_name, address, comment
FROM pg_hba_file_rules
WHERE user_name[1]='jim';
type | database | user_name | address | comment
------+----------+-----------+-----------+---------
host | {db} | {jim} | 127.0.0.1 | foo
host | {db} | {jim} | 127.0.0.1 | bar
host | {db} | {jim} | 127.0.0.1 | #foo#
(3 rows)
This feature can come in quite handy when we need to read important
comments from the hba entries without having access to the pg_hba.conf
file directly.
The patch slightly changes the test 004_file_inclusion.pl to accommodate
the new column and the hba comments.
Discussion:
https://www.postgresql.org/message-id/flat/3fec6550-93b0-b542-b203-b0054aaee83b%40uni-muenster.de
Best regards,
Jim
Вложения
В списке pgsql-hackers по дате отправления: