Wait, what, it's 2021 and #postgres can't auto-generate UUIDs?
Sad, it seems that an extension is required for that to work; just spinning a docker container is not enough.
Conversation
Replying to
Postgres 13 has gen_random_uuid() function in core - no extension required. Though installing a contrib extension should be easy on most platforms.
Replying to
Good to know, thanks. I'll look into it. Can that function be used to let PGSQL automatically assign a UUID to a column upon insert?
I understand that installing an extension is easy, but the point of Docker images is to not have to worry about/fiddle with what's inside