Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwadm_functions
Fields
Name | Data type | Description |
---|---|---|
dvnaam |
text |
|
dvfunctionname |
text |
|
Rules
Name | Event | Instead | Condition | Description |
---|---|---|---|---|
_RETURN |
SELECT |
|
|
Indices
There are no indices for table vwadm_functions
Definition
CREATE VIEW public.vwadm_functions (
dvnaam,
dvfunctionname)
AS
SELECT upper(p.proname::text) AS dvnaam,
lower(p.proname::text) AS dvfunctionname
FROM pg_namespace n
JOIN pg_proc p ON p.pronamespace = n.oid
WHERE n.nspname = 'public'::name AND (upper(p.proname::text) ~~ 'FN_%'::text OR
upper(p.proname::text) = 'INSTR'::text OR p.probin IS NOT NULL)
GROUP BY p.proname;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
![]() ![]() ![]() |