blob: e69212ed63958304fea02a6a8064b9025f80c01a (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
QUERY: VACUUM;
QUERY: SELECT relname, relhasindex
FROM pg_class
WHERE relhasindex
ORDER BY relname;
relname |relhasindex
--------------+-----------
bt_c16_heap |t
bt_f8_heap |t
bt_i4_heap |t
bt_txt_heap |t
fast_emp4000 |t
hash_c16_heap |t
hash_f8_heap |t
hash_i4_heap |t
hash_txt_heap |t
ihighway |t
onek |t
pg_attrdef |t
pg_attribute |t
pg_class |t
pg_description|t
pg_proc |t
pg_relcheck |t
pg_trigger |t
pg_type |t
road |t
shighway |t
tenk1 |t
tenk2 |t
(23 rows)
|