How to specify random default value for UUID column?

There is timestamp column that can have "special" default value now.

For UUID columns such "special" value is newly generated UUID, in Postgres typically expressed as gen_random_uuid() or uuid_generate_v4() but none of them seem to work in xano.

To me this is the first step to enable people to migrate to uuids manually by having two id fields (default numeric primary key and new unique uuid) and then gradually migrate application to use uuid as identifier. Having to use function stack to such simple task as generating UUID is a pain especially if there are multiple endpoints that are adding records to such table.

Is there another way to specify default value for uuid column?

Do you plan to add such functionality and if yes, what is the timeline?

4 replies