GP - display the db configuration

To display database level configuration.

Two options are given using an if condition. This will help to list down single or all configurations.

$where_addtnl= "all"

or

$where_addtnl= "$configname"

with seg_parms AS

   ( SELECT paramname,

        CASE WHEN array_upper(seg_vals,1) > 3

        THEN (seg_vals[1] || ';' || seg_vals[2] || ';' || seg_vals[3] || '....')

        ELSE array_to_string(seg_vals,';')

        END AS seg_vals

        FROM

        (

           SELECT paramname,

           array_agg(distinct paramvalue) AS seg_vals

           FROM gp_toolkit.gp_param_settings()

           GROUP BY 1

        ) a

    )

SELECT name AS \"Name\",

setting || coalesce(unit,'') AS \"Master Setting\",

seg_vals AS \"Distinct Segment Settings\",

min_val AS \"Min Val\",

max_val AS \"Max Val\",

source AS \"Source\"

FROM pg_settings m, seg_parms s

WHERE m.name = s.paramname

AND $where_addtnl

ORDER BY name;