SQL PostgreSQL Create Table with GUID Primary Key - gecko-8/devwiki GitHub Wiki

CREATE TABLE <table name> (
    <primary key name> uuid PRIMARY KEY DEFAULT gen_random_uuid()
    ...
);