I'm trying to get a list of schemata in PostgreSQL (9.6) along with any comments which might have been added...
This works great to get a list of schema names:
select schema_name
from information_schema.schemata
...but how do you get the associated comment (if there is one) as well?
- I've found loads of stuff to get database/table/column comments... schema comments seem to be evading me?
Any help gratefully received!