Add UUID column

[Vladimir-Va]

Please add autogenerated UUID column.

[wingkwong]

By default, when you create a table, it only gives you auto-increment ID (the default one). However, you can add a column with autogenerated UUID with the following steps.

• Create a column with Column Type SpecificDBType
• Select uuid in Type in Database
• Input your generation function in Default value box. Let's take Postgres as an example, one of the possible function is md5(random()::text || clock_timestamp()::text)::uuid. The function depends on the database you are using
• Mark it as PK

After that, you can delete the default ID column. When you insert a new record, you should see a generated UUID.

[Vladimir-Va]

I try it, i can create trigger for UUID in MariaDB

but can't from NocoDB GUI

Now i need add trigger as first screenshot
Add column SpecificDBType uuid varchar(36) (no have uuid type) and this work.
Hoped that we can do without PhpMyAdmin.
But if setup UUID column as PK we have error uuid field must be filled.

[Sov3rain]

Another option to create an uuid when using a postgresQL database is using a postgres function:

• Create a column with a type of SpecificDBType
• Select uuid as the type
• In the default value text box, add gen_random_uuid()

You're good to go.

[o1lab]

I see its locked into certain types.

What I assume we need is a template when creating tables.

[Vladimir-Va]

Or support something like create trigger field.