Jeremy Schneider ardentperf

building and running reliable data platforms that scale and perform. my opinions are my own.

fabriziomello / gapless_sequence.sql

Last active July 22, 2024 07:01

Gapless sequence example in PostgreSQL

	CREATE TABLE public.gapless_sequence (
	sequence_schema TEXT,
	sequence_name TEXT,
	last_value BIGINT DEFAULT 0,
	step INTEGER DEFAULT 1
	);

	ALTER TABLE public.gapless_sequence
	ADD CONSTRAINT gapless_sequence_pk PRIMARY KEY (sequence_schema, sequence_name);