CUSTOM in ALTER TYPE #590

^{Originally posted by gramian October 25, 2022}
Dear Community,

The ALTER TYPE SQL statement has a CUSTOM key = value component, which I don't understand: There seems to be no alteration on the to-be-altered type if used. I assumed CUSTOM works similar to the SQL COMMENT ON statement. Could you resolve what I am misunderstanding or misinterpreting here? Thank you.

PS: If it is supposed to work like COMMENT ON, is there a way use the equivalent of COMMENT ON DATABASE IS? I tried ALTER TYPE schema:database CUSTOM comment = "a database" which does not work; I assume schema:database is protected in some way.