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

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.