top | item 39261051

(no title)

naranha | 2 years ago

Does this stay compatible with the old uuid column type, as uuidv7() uses the same 128 bit format as gen_random_uuid()?

That would mean it's easy to update old apps, as we would only have to change the default value for the columns.

discuss

order

pgaddict|2 years ago

Yes, internally it's the same as every other UUID (16 bytes, passed by reference). There's no reason to store / represent it differently.

mplanchard|2 years ago

Yes, we have already updated our in-app UUID generation to use v7 UUIDs and are storing them in regular postgres UUID columns (postgres 14). Works great!

Merad|2 years ago

Yes, you can use v7 today with uuid columns, you just need to add a custom function (or the more performant pg_uuidv7 extension) to generate them.