Datadictionary OpenWave 3.1.11 |
|
View: vwadm_tablecolumncount
Datadictionary OpenWave 3.1.11 |
|
View: vwadm_tablecolumncount
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwadm_tablecolumncount
Fields
Name | Data type | Description |
|---|---|---|
dvtablename |
text |
|
dncolumncount |
bigint |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dvtablename,
dncolumncount)
AS
SELECT upper(pg_class.relname::text) AS dvtablename,
count(pg_attribute.*) AS dncolumncount
FROM pg_attribute
JOIN pg_class ON pg_class.oid = pg_attribute.attrelid
WHERE upper(pg_class.relname::text) ~~ 'TB%'::text AND pg_class.relkind =
'r'::"char" AND pg_attribute.attnum > 0 AND pg_attribute.attstattarget < 0
GROUP BY pg_class.relname;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|