pub const LIST_EXTENSIONS_QUERY: &str = r#"select
distinct on
(name) *
from
(
select
name,
version,
enabled,
schema,
description
from
(
select
t0.extname as name,
t0.extversion as version,
true as enabled,
t1.nspname as schema,
comment as description
from
(
select
extnamespace,
extname,
extversion
from
pg_extension
) t0,
(
select
oid,
nspname
from
pg_namespace
) t1,
(
select
name,
comment
from
pg_catalog.pg_available_extensions
) t2
where
t1.oid = t0.extnamespace
and t2.name = t0.extname
) installed
union
select
name,
default_version as version,
false as enabled,
'public' as schema,
comment as description
from
pg_catalog.pg_available_extensions
order by
enabled asc
) combined
order by
name asc,
enabled desc
"#;