PostgreSQL

Enable UUID on PostgreSQL

Sometimes we want to have native support for UUID’s in Postgres, fortunately there is already a ready-made extension that makes it easy.

Enter the “uuid-ossp” extension… fortunately furthermore, its very easy to use…

  1. Enable the extension:

    CREATE EXTENSION IF NOT EXISTS “uuid-ossp”

  2. Set default value on the column to “expression” and use the following default value:

    uuid_generate_v4()

Advertisements