Skip to content

Instantly share code, notes, and snippets.

View daspn-dock's full-sized avatar

Daniel Nunes daspn-dock

  • Dock
  • Rio de Janeiro
View GitHub Profile
@daspn-dock
daspn-dock / generate_ulid.sql
Created June 15, 2022 20:30
PostgreSQL function to generate an unique ID of type ULID
CREATE EXTENSION IF NOT EXISTS pgcrypto;
CREATE OR REPLACE FUNCTION generate_ulid() RETURNS uuid
AS $$
SELECT (lpad(to_hex(floor(extract(epoch FROM clock_timestamp()) * 1000)::bigint), 12, '0') || encode(gen_random_bytes(10), 'hex'))::uuid;
$$ LANGUAGE SQL;