Re: control pg_hba.conf via SQL

[Andrew Dunstan <andrew(at)dunslane(dot)net>]

A.M. wrote:
> Could postgres offer at least a read-only view of the data in the interim?
> Ordering could be controlled by line number.
>   

You can get the contents as a single text field like this:

|  select pg_read_file|('pg_hba.conf', 0, 50*1024);


Writing a plperl function that would strip comments and blank lines and 
return the rest as a numbered set of lines would be fairly trivial.


cheers

andrew