Datadictionary OpenWave 3.1.11 |
|
View: vwadm_tablecolumns
Datadictionary OpenWave 3.1.11 |
|
View: vwadm_tablecolumns
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwadm_tablecolumns
Fields
Name | Data type | Description |
|---|---|---|
dvnaam |
varchar(61) |
|
dvcolumnname |
varchar(61) |
|
dvcomment |
varchar(4000) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dvnaam,
dvcolumnname,
dvcomment)
AS
SELECT (((upper(b.relname::text) || '.'::text) ||
upper(a.attname::text)))::character varying(61) AS dvnaam,
(((lower(b.relname::text) || '.'::text) ||
lower(a.attname::text)))::character varying(61) AS dvcolumnname,
col_description(b.oid, a.attnum::integer)::character varying(4000) AS dvcomment
FROM pg_attribute a
JOIN pg_class b ON b.oid = a.attrelid
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 22-2-2017 10:50 |
|