PostgreSQL Catalogs:
Table Attributes by Schema & Table
This is an example of a three level report with two variables,
schema name and table name.
This report also shows fun with colors and tables.
|
Relation Type Key
|
|
|
Table
|
|
View
|
|
Index
|
|
Sequence
|
|
Special
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
r_name
|
text
|
|
|
r_title
|
text
|
|
|
ag_name
|
text
|
|
|
rt_type
|
text
|
|
|
r_sdesc
|
text
|
|
|
r_ldesc
|
text
|
|
|
ag_desc
|
text
|
|
|
rt_desc
|
text
|
|
|
pr_name
|
text
|
|
|
rp_order
|
integer
|
|
|
label
|
text
|
|
|
def
|
text
|
|
|
domain
|
text
|
|
|
domcount
|
integer
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
ag_name
|
text
|
NOT NULL
|
|
ag_owner
|
text
|
|
|
ag_desc
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
ag_name
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
pr_name
|
text
|
NOT NULL
|
|
pr_label
|
text
|
|
|
pr_default
|
text
|
|
|
pr_domain
|
text
|
|
|
pr_domcount
|
integer
|
HAS DEFAULT
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
pr_name
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
r_name
|
text
|
NOT NULL
|
|
rt_type
|
text
|
NOT NULL
|
|
ag_name
|
text
|
|
|
r_title
|
text
|
|
|
r_sdesc
|
text
|
|
|
r_ldesc
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
r_name
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
r_name
|
text
|
NOT NULL
|
|
pr_name
|
text
|
NOT NULL
|
|
rp_order
|
integer
|
HAS DEFAULT
|
|
rp_label
|
text
|
|
|
rp_default
|
text
|
|
|
rp_domain
|
text
|
|
|
rp_domcount
|
integer
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
r_name
|
text
|
|
|
pr_name
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
rt_type
|
text
|
NOT NULL
|
|
rt_desc
|
text
|
NOT NULL
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
rt_type
|
text
|
|
|