Background
Now that we have a couple of functions written, let us see how to review metadata on functions.
Code
SQL
select
tblNS.nspname
, tblP.proname
, tblLang.lanname
as "language"
, tblAuth.rolname
as "owner"
, tblP.prokind
, tblType.typname
as "returnType"
, tblP.proparallel
, tblP.provolatile
, tblP.oid::regprocedure
as "syntax"
, tblP.proargnames
, tblP.prosrc
from pg_catalog.pg_proc tblP
inner join pg_catalog.pg_namespace tblNS
on tblP.pronamespace = tblNS.oid
join pg_catalog.pg_authid tblAuth
on tblP.proowner = tblAuth.oid
join pg_catalog.pg_language tblLang
on tblP.prolang = tblLang.oid
join pg_catalog.pg_type tblType
on tblP.prorettype = tblType.oid
where tblNS.nspname not in
(
'information_schema'
, 'pg_catalog'
)
Output
GUI
DBeaver
Outline
To review function properties, please do the following :-
- Launch DBeaver
- Connect to PostgreSQL Instance
- Navigate to Schema \ {Schema} \ Functions \ {Function}
- Function Parameters
- Navigate on Selection
- From the drop down menu, please choose “Function Parameters”
Image
Image – Function Parameters
Image – Function Dependencies
Image – Function Properties/Statistics/Flags
Image – Function – Permissions
Image – Function – Source
l
