Database UUID Generator

Native UUID/GUID functions for PostgreSQL and SQL Server, with examples.

PostgreSQL UUID Type Setup

-- enable extension
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";
-- generate v4
SELECT uuid_generate_v4();
-- table usage
CREATE TABLE users (
  id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
  name TEXT
);

SQL Server Create GUID

-- NEWID() (random GUID)
SELECT NEWID();
-- table usage
CREATE TABLE Users (
  Id UNIQUEIDENTIFIER DEFAULT NEWID() PRIMARY KEY,
  Name NVARCHAR(100)
);