Skip to content

Instantly share code, notes, and snippets.

@cdmckay

cdmckay/uuid_to_bytea.sql

Last active December 23, 2022 02:13
Show Gist options
  • Save cdmckay/a82261e48a42a3bbd78a to your computer and use it in GitHub Desktop.
Save cdmckay/a82261e48a42a3bbd78a to your computer and use it in GitHub Desktop.
Download ZIP
How to convert a PostgreSQL UUID to bytea
Raw
uuid_to_bytea.sql
select decode(replace('45774962-e6f7-41f6-b940-72ef63fa1943'::text, '-', ''), 'hex');
-- And here's how to convert it to the ShortUUID format used in Process Street
select replace(encode(substring(decode(replace('45774962-e6f7-41f6-b940-72ef63fa1943'::text, '-', ''), 'hex') from 9 for 8) ||
substring(decode(replace('45774962-e6f7-41f6-b940-72ef63fa1943'::text, '-', ''), 'hex') from 1 for 8), 'base64'), '=', '');
@aleclarson
Copy link

@will any idea what the use case for void_send would be? how is it even called?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment