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'), '=', '');
@Mart-Bogdan
Copy link

@will thank you!

@will
Copy link

will commented Feb 8, 2021 •
edited
Loading

@Mart-Bogdan

@will thank you!

:)

Also in case you didn’t know (and anyone in the future) there is a _send function for all data types, if you want to get the internal binary representation of the data. Just something to keep in the back of your mind, I find it's handy to know like once every few years

@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