The pg_type_encoding system catalog table contains the column storage type information.

    columntypemodifersstoragedescription
    typeidoidnot nullplainForeign key to pg_attribute
    typoptionstext [ ] extendedThe actual options

    Parent topic: System Catalogs Definitions