On Fri, Feb 18, 2022 at 3:06 PM Laura Smith <n5d9xq3ti233xiyif2vp@xxxxxxxxxxxxx> wrote: > Is there anything inherently "special" about the UUID type ? i.e. if I store a UUID in a text is it "worse" ? uuid is stored as 16 binary bytes. Store it as text, and that's 36 chars (assuming UTF-8, double-that in UTF-16, if that's possible in PG). Or encode it as base-62 instead of hexa (base-16, with dashes), to use only 22 chars as text (in UTF-8 or ASCII)
