Generate string of function names installed by PostgreSQL extensions, for filtering *in* in DBeaver UI

generate_dbeaver_function_name_include_filter.sql

with function_names (name) as (
  SELECT
  p.proname AS function_name
FROM
  pg_proc p
LEFT JOIN
  pg_depend d ON d.objid = p.oid 
  AND
  d.deptype = 'e'
WHERE
  p.pronamespace = 'public'::regnamespace
AND
  d.objid IS NULL
AND
  p.prokind = 'f'
ORDER BY
  function_name
)
select array_to_string(
  array(select * from function_names),
  '|'
);