I have used '-- ' to enter comments about tables or columns and am curious about the value of storing comments in tables using the COMMENT key word. When is the latter more appropriate than the former?
Description entered with COMMENT statements is persistently saved in database system catalogue - see table pg_description. You can get the comment for any database object.
Comments like '--' or '/* ... */ are comments in source code, and they are just ignored in processing.