11 lines
236 B
MySQL
11 lines
236 B
MySQL
|
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
|