Re: pg_hba_file_settings view patch - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: pg_hba_file_settings view patch
Date
Msg-id CAB7nPqSgf46XOr3E0T_juXqwbtd_JyRmVXLZnM4iUwi8CRASGg@mail.gmail.com
Whole thread Raw
In response to Re: pg_hba_file_settings view patch  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
Responses Re: pg_hba_file_settings view patch  (Vitaly Burovoy <vitaly.burovoy@gmail.com>)
List pgsql-hackers
On Mon, Oct 3, 2016 at 3:25 PM, Vitaly Burovoy <vitaly.burovoy@gmail.com> wrote:
> I guess for ability to use filtering like:
>
> SELECT * FROM pg_hba_rules WHERE options->>radiusserver LIKE '%.example.com';
>
> I think it would be harder if options is an array of strings...

With unnest() and a matching pattern, not that hard but..
-- 
Michael



pgsql-hackers by date:

Previous
From: Vitaly Burovoy
Date:
Subject: Re: pg_hba_file_settings view patch
Next
From: Michael Paquier
Date:
Subject: Re: Tracking wait event for latches