Datadictionary OpenWave 3.1.25

View: vwadm_defaults

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwadm_defaults

Fields

Rules

Indices

There are no indices for table vwadm_defaults

Definition

CREATE VIEW public.vwadm_defaults (
   dvnaam,
   dvdefaultwaarde)
AS
SELECT (upper(pg_class.relname::text) || '.'::text) ||
   upper(pg_attribute.attname::text) AS dvnaam,
   pg_get_expr(pg_attrdef.adbin, pg_attrdef.adrelid) AS dvdefaultwaarde
FROM pg_attribute
    JOIN pg_attrdef ON pg_attribute.attnum = pg_attrdef.adnum
    JOIN pg_class ON pg_attrdef.adrelid = pg_class.oid AND
        pg_attribute.attrelid = pg_class.oid
WHERE pg_attribute.atthasdef = true AND pg_attribute.attnotnull = false;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13