Find comments on database objects

If you need to check which of your objects have comments you can use this select:

select ns.nspname as schema_name,
c.relname as table_name, 
a.attname as column_name,
d.description as "comment"
from pg_description d
join pg_class c
on d.objoid=c.oid
join pg_namespace ns
on c.relnamespace=ns.oid
left join pg_attribute a
on d.objoid=a.attrelid and d.objsubid=a.attnum