Comment by IiydAbITMvJkqKf

UUIDs are not text. Most uuid parsers ignore hyphens and braces, so citext will not help you.

Use the native uuid type, or as a fallback, store it in a 16 byte binary blob.