sql.functions_without_description.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of pg-index-health-core Show documentation

pg-index-health-core is a Java library for analyzing and maintaining indexes and tables health in PostgreSQL databases on a specific host.

There is a newer version: 0.14.4

Show newest version

/*
 * Copyright (c) 2019-2024. Ivan Vakhrushev and others.
 * https://github.com/mfvanek/pg-index-health-sql
 *
 * Licensed under the Apache License 2.0
 */

-- Finds functions and procedures that don't have a description.
-- See also https://www.postgresql.org/docs/current/sql-comment.html
select
    case when nsp.nspname = 'public'::text then p.proname else nsp.nspname || '.' || p.proname end as function_name,
    pg_get_function_identity_arguments(p.oid) as function_signature
from
    pg_catalog.pg_namespace nsp
    inner join pg_catalog.pg_proc p on p.pronamespace = nsp.oid
where
    (obj_description(p.oid) is null or length(trim(obj_description(p.oid))) = 0) and
    nsp.nspname = :schema_name_param::text
order by function_name, function_signature;