add pg_idkit extension

[gperdomor]

Feature request

Additional context

Based on supabase blog post, would be nice having this extension in the docker image

[iveshenry18]

Seconding this request—bit of a bait-and-switch to recommend this in a blog post but not support it!

Nonetheless, really appreciate what this team has built.

[olirice]

The bar for adding new extensions to the platform is very high. In pg_idkit's case, we're instead pushing for adopting the functionality via a trusted language extension to put the control in users' hands. We're developing tooling to make that process smoother but in the short term you can copy the implementations of gen_random_uuidv6 or gen_random_uuidv7 from here for use in your projects

That project is also available on dbdev