Version 2021

Table Comments

In PostgreSQL, COMMENT stores a comment about a database object. More details can be found in SQL Commands on the PostgreSQL site.

MicroStrategy does not read table comments specifically from a data source. However, these values can be selected from system tables via freeform SQLwith the appropriate access to the warehouse database. Here is an example of reading a comment on the nation table: 

Copy
select description from pg_description 
join pg_class on pg_description.objoid = pg_class.oid 
where relname = 'nation'

There is no special handling on the MicroStrategy side.