create schema typemodtest; create type typemodtest.my_rec as ( coll_no_typemod collection, coll_typemod_int collection('int'), icoll_no_typemod icollection, icollection_typemod_varchar icollection('varchar') ); \d typemodtest.my_rec Composite type "typemodtest.my_rec" Column | Type | Collation | Nullable | Default -----------------------------+----------------------------------+-----------+----------+--------- coll_no_typemod | collection | | | coll_typemod_int | collection('integer') | | | icoll_no_typemod | icollection | | | icollection_typemod_varchar | icollection('character varying') | | | drop schema typemodtest cascade; NOTICE: drop cascades to type typemodtest.my_rec