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
|
|
akey
|
text
|
NOT NULL
|
|
area
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
akey
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
ename
|
text
|
NOT NULL
|
|
year
|
integer
|
|
|
descr
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
ename
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
sname
|
text
|
NOT NULL
|
|
tykey
|
text
|
|
|
akey
|
text
|
|
|
tname
|
text
|
|
|
city
|
text
|
|
|
state
|
text
|
|
|
country
|
text
|
|
|
descr
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
sname
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
sname
|
text
|
|
|
tykey
|
text
|
|
|
akey
|
text
|
|
|
tname
|
text
|
|
|
city
|
text
|
|
|
state
|
text
|
|
|
country
|
text
|
|
|
descr
|
text
|
|
|
ttype
|
text
|
|
|
area
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
matid
|
integer
|
NOT NULL HAS DEFAULT
|
|
team1
|
text
|
|
|
team2
|
text
|
|
|
score1
|
integer
|
|
|
score2
|
integer
|
|
|
venue
|
text
|
|
|
descr
|
text
|
|
|
|
|
|
Sequence: tmatches_matid_seq
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
sequence_name
|
name
|
NOT NULL
|
|
last_value
|
bigint
|
NOT NULL
|
|
increment_by
|
bigint
|
NOT NULL
|
|
max_value
|
bigint
|
NOT NULL
|
|
min_value
|
bigint
|
NOT NULL
|
|
cache_value
|
bigint
|
NOT NULL
|
|
log_cnt
|
bigint
|
NOT NULL
|
|
is_cycled
|
boolean
|
NOT NULL
|
|
is_called
|
boolean
|
NOT NULL
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
matid
|
integer
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
tykey
|
text
|
NOT NULL
|
|
ttype
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
tykey
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
vidid
|
integer
|
NOT NULL HAS DEFAULT
|
|
vidord
|
integer
|
NOT NULL
|
|
matdid
|
integer
|
|
|
descr
|
text
|
|
|
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
vidid
|
integer
|
|
|
vidord
|
integer
|
|
|
|
|
|
Sequence: videos_vidid_seq
|
|
|
|
|
|
|
Column
|
Type
|
Modifiers
|
|
sequence_name
|
name
|
NOT NULL
|
|
last_value
|
bigint
|
NOT NULL
|
|
increment_by
|
bigint
|
NOT NULL
|
|
max_value
|
bigint
|
NOT NULL
|
|
min_value
|
bigint
|
NOT NULL
|
|
cache_value
|
bigint
|
NOT NULL
|
|
log_cnt
|
bigint
|
NOT NULL
|
|
is_cycled
|
boolean
|
NOT NULL
|
|
is_called
|
boolean
|
NOT NULL
|
|