Datadictionary OpenWave 3.1.32
Previous topic Chapter index Next topic

View: vwadm_functions

 

 

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
Previous topic Chapter index Next topic