Datadictionary OpenWave 3.1.25

View: vwadm_tablecolumns

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwadm_tablecolumns

Fields

Rules

Indices

There are no indices for table vwadm_tablecolumns

Definition

CREATE VIEW public.vwadm_tablecolumns (
   dvnaam,
   dvcolumnname,
   dvcomment,
   dvdata_type,
   dnmax_length)
AS
SELECT (upper(b.relname::text) || '.'::text) || upper(a.attname::text) AS dvnaam,
   (lower(b.relname::text) || '.'::text) || lower(a.attname::text) AS dvcolumnname,
   col_description(b.oid, a.attnum::integer)::character varying(4000) AS dvcomment,
   columns.data_type AS dvdata_type,
   columns.character_maximum_length AS dnmax_length
FROM pg_attribute a
    JOIN pg_class b ON b.oid = a.attrelid
    JOIN information_schema.columns ON b.relname = columns.table_name::name
        AND a.attname = columns.column_name::name
WHERE upper(b.relname::text) ~~ 'TB%'::text AND b.relkind = 'r'::"char" AND
   a.attnum > 0 AND a.attstattarget < 0;

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