dev=> create table t1 (v1 int, v2 int);
CREATE_TABLE
dev=> create index t1_idx1 on t1(v1);
CREATE_INDEX
dev=> create materialized view mv1 as select * from t1;
CREATE_MATERIALIZED_VIEW
dev=> SELECT c.relname,a.*,pg_catalog.pg_get_expr(ad.adbin, ad.adrelid, true) as def_value,dsc.description
FROM pg_catalog.pg_attribute a
INNER JOIN pg_catalog.pg_class c ON (a.attrelid=c.oid)
LEFT OUTER JOIN pg_catalog.pg_attrdef ad ON (a.attrelid=ad.adrelid AND a.attnum = ad.adnum)
LEFT OUTER JOIN pg_catalog.pg_description dsc ON (c.oid=dsc.objoid AND a.attnum = dsc.objsubid)
WHERE NOT a.attisdropped ORDER BY a.attnum;
 relname | attrelid | attname | atttypid | attlen | attnum | attnotnull | attisdropped | def_value | description
---------+----------+---------+----------+--------+--------+------------+--------------+-----------+-------------
 mv1     |     1663 | v1      |       23 |      4 |      1 | f          | f            |           |
 t1      |     1660 | v1      |       23 |      4 |      1 | f          | f            |           |
 t1_idx1 |     1662 | v1      |       23 |      4 |      1 | f          | f            |           |
 mv1     |     1663 | v2      |       23 |      4 |      2 | f          | f            |           |
 t1      |     1660 | v2      |       23 |      4 |      2 | f          | f            |           |
 t1_idx1 |     1662 | v2      |       23 |      4 |      2 | f          | f            |           |
(6 rows)

dev=> SELECT a.oid,a.*,pd.description FROM pg_catalog.pg_roles a
left join pg_catalog.pg_shdescription pd on a.oid = pd.objoid
ORDER BY a.rolname;
 oid | oid | rolname  | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolpassword | description
-----+-----+----------+----------+------------+---------------+-------------+-------------+-------------+-------------
   2 |   2 | postgres | t        | t          | t             | t           | t           | ********    |
   1 |   1 | root     | t        | t          | t             | t           | t           | ********    |
(2 rows)