Friday, 24 January 2025

Filled under:

SELECT 

    p.proname AS function_name,

    r.rolname AS owner_name

FROM 

    pg_proc p

JOIN 

    pg_roles r ON p.proowner = r.oid

WHERE 

    p.proname = 'my_function';



SELECT 
    p.proname AS function_name,
    r.rolname AS owner_name
FROM 
    pg_proc p
JOIN 
    pg_roles r ON p.proowner = r.oid
WHERE 
    p.proname = 'your_function_name';

0 comments:

Post a Comment