Hacker News new | ask | show | jobs
by IiydAbITMvJkqKf 1584 days ago
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.