Zabbix

WITH T AS (

    SELECT

        datname AS "{#DBNAME}"

    FROM pg_database

    WHERE

        NOT datistemplate

        AND datname != 'postgres'

)

SELECT '{"data":'|| regexp_replace(coalesce(json_agg(T), '[]'::json)::text, E'[\\n\\r\\s]+', '', 'g') || '}'

FROM T