Postgres Table with UUID Primary key

uuid.sql

-- Turn on the pgcrypto extension which should be installed
-- by default in recent Postgres builds.
CREATE EXTENSION pgcrypto;

-- Create a table with the primary key as an UUID
-- using the gen_random_uuid() function which is 
-- available through the pgcrypto extension.
CREATE TABLE tbl_sometable
(
  id uuid NOT NULL DEFAULT gen_random_uuid(),
  name text,
  tags text,
  CONSTRAINT tbl_sometable_pkey PRIMARY KEY (id)
);