[welder]

Now you can use PG to generate the UUIDv7 in the beginning then easily switch to generating in the client if you need in the future, but I think OP was talking about UUID vs auto-incrementing integer in general not specific to Postgres.

[lazide]

IMO it’s always been easier to generate them in the client. Every major platform has had libraries since forever.