Can IDENTITY COLUMNS generate UUIDs?

5 votes

2 answers

6824 views

postgresql identity sql-standard uuid postgresql-10

                          I'm just wondering if either the spec of the implementation (PostgreSQL) provides for generating identity columns from UUIDs or the like.

Is there an alternative to,

    CREATE TABLE f (
      id uuid DEFAULT gen_random_uuid()
    );

Especially one that can protect the column under GENERATED ALWAYS
                        

Asked by Evan Carroll (65502 rep)

Jan 3, 2018, 12:22 AM
Last activity: Apr 30, 2024, 03:12 PM

Can IDENTITY COLUMNS generate UUIDs?

Related Questions