Datadictionary OpenWave 3.1.35

View: vwadm_objectcount

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwadm_objectcount

Columns

Rules

Indices

There are no indices for table vwadm_objectcount

Definition

CREATE VIEW public.vwadm_objectcount (
   object,
   aantal,
   status)
AS
SELECT 'TABLECOLUMN'::text AS object,
   sum(c.column_count) AS aantal,
   'NVT'::text AS status
FROM (
   SELECT count(*) AS column_count
   FROM information_schema.columns c_1
            JOIN information_schema.tables v ON c_1.table_name::name =
                v.table_name::name AND c_1.table_schema::name = v.table_schema::name
   WHERE (c_1.table_schema::name <> ALL (ARRAY['pg_catalog'::name,
       'information_schema'::name])) AND upper(c_1.table_name::text) ~~ 'TB%'::text
   GROUP BY c_1.table_name
   ) c
UNION
SELECT 'VIEWCOLUMN'::text AS object,
   sum(c.column_count) AS aantal,
   'NVT'::text AS status
FROM (
   SELECT count(*) AS column_count
   FROM information_schema.columns c_1
            JOIN information_schema.views v ON c_1.table_name::name =
                v.table_name::name AND c_1.table_schema::name = v.table_schema::name
   WHERE (c_1.table_schema::name <> ALL (ARRAY['pg_catalog'::name,
       'information_schema'::name])) AND upper(c_1.table_name::text) ~~ 'VW%'::text
   GROUP BY c_1.table_name
   ) c
UNION
SELECT 'PRIMARY KEY'::text AS object,
   count(pg_constraint.conname) AS aantal,
   'NVT'::text AS status
FROM pg_constraint
WHERE pg_constraint.contype = 'p'::"char" AND
   upper(pg_constraint.conname::text) ~~ 'CPK_%'::text
UNION
SELECT 'FOREIGN KEY'::text AS object,
   count(pg_constraint.conname) AS aantal,
   'NVT'::text AS status
FROM pg_constraint
WHERE pg_constraint.contype = 'f'::"char" AND
   upper(pg_constraint.conname::text) ~~ 'CFK_%'::text
UNION
SELECT 'NOT NULL'::text AS object,
   count(pg_constraint.conname) AS aantal,
   'NVT'::text AS status
FROM pg_constraint
WHERE pg_constraint.contype = 'c'::"char" AND
   upper(pg_constraint.conname::text) ~~ 'CNN_%'::text
UNION
SELECT 'CHECK'::text AS object,
   count(pg_constraint.conname) AS aantal,
   'NVT'::text AS status
FROM pg_constraint
WHERE pg_constraint.contype = 'c'::"char" AND
   upper(pg_constraint.conname::text) ~~ 'CHK_%'::text
UNION
SELECT 'FUNCTION'::text AS object,
   count(p.proname) AS aantal,
   'NVT'::text AS status
FROM pg_namespace n
    JOIN pg_proc p ON p.pronamespace = n.oid
WHERE n.nspname = 'public'::name
UNION
SELECT 'DEFAULT'::text AS object,
   count(pg_attribute.attname) AS aantal,
   'NVT'::text AS status
FROM pg_attribute
WHERE pg_attribute.atthasdef = true AND pg_attribute.attnotnull = false
UNION
SELECT 'INDEX'::text AS object,
   count(*) AS aantal,
   'NVT'::text AS status
FROM pg_indexes
WHERE upper(pg_indexes.indexname::text) ~~ 'IDX_%'::text
UNION
SELECT 'INDEXUNIQUE'::text AS object,
   count(*) AS aantal,
   'NVT'::text AS status
FROM pg_indexes
WHERE upper(pg_indexes.indexname::text) ~~ 'IDU_%'::text
UNION
SELECT 'SEQUENCE'::text AS object,
   count(*) AS aantal,
   'NVT'::text AS status
FROM information_schema.sequences s
    JOIN information_schema.columns c ON s.sequence_schema::name =
        c.table_schema::name AND s.sequence_name::name = regexp_replace(c.column_default::text, '^nextval\(''([^'']+)''::regclass\)$'::text, '\1'::text)
WHERE upper(c.table_name::text) ~~ 'TB%'::text
UNION
SELECT 'VIEW'::text AS object,
   count(*) AS aantal,
   'NVT'::text AS status
FROM information_schema.views
WHERE upper(views.table_name::text) ~~ 'VW%'::text AND NOT
   upper(views.table_name::text) ~~ 'VWADM_%'::text AND NOT upper(views.table_name::text) ~~ 'VWBI_%'::text
UNION
SELECT 'ADMINVIEW'::text AS object,
   count(*) AS aantal,
   'NVT'::text AS status
FROM information_schema.views
WHERE upper(views.table_name::text) ~~ 'VWADM_%'::text
UNION
SELECT 'BIVIEW'::text AS object,
   count(*) AS aantal,
   'NVT'::text AS status
FROM information_schema.views
WHERE upper(views.table_name::text) ~~ 'VWBI_%'::text
UNION
SELECT 'TABLE'::text AS object,
   count(*) AS aantal,
   'NVT'::text AS status
FROM information_schema.tables
WHERE upper(tables.table_name::text) ~~ 'TB%'::text
UNION
SELECT 'TRIGGER'::text AS object,
   count(pg_trigger.tgname) AS aantal,
   'NVT'::text AS status
FROM pg_trigger
WHERE upper(pg_trigger.tgname::text) ~~ 'TRIG_%'::text
ORDER BY 1;

This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 26/10/2026 11:10