19 lines
371 B
MySQL
19 lines
371 B
MySQL
|
SELECT md5(
|
||
|
|
json_build_object(
|
||
|
|
'extensions', (
|
||
|
|
SELECT array_agg(extname) FROM (
|
||
|
|
SELECT extname
|
||
|
|
FROM pg_extension
|
||
|
|
ORDER BY extname
|
||
|
|
) AS e
|
||
|
|
),
|
||
|
|
'settings', (
|
||
|
|
SELECT json_object(array_agg(name), array_agg(setting)) FROM (
|
||
|
|
SELECT name, setting
|
||
|
|
FROM pg_settings
|
||
|
|
WHERE name != 'application_name'
|
||
|
|
ORDER BY name
|
||
|
|
) AS s
|
||
|
|
)
|
||
|
|
)::text);
|