pg_text_semver

pg_text_semver : Semantic version domain and comparison operators for PostgreSQL

Overview

Packages

Source

pig build pkg pg_text_semver;		# build rpm/deb

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

pig install pg_text_semver;		# install via package name, for the active PG version

pig install pg_text_semver -v 18;   # install for PG 18
pig install pg_text_semver -v 17;   # install for PG 17
pig install pg_text_semver -v 16;   # install for PG 16
pig install pg_text_semver -v 15;   # install for PG 15
pig install pg_text_semver -v 14;   # install for PG 14

Create this extension with:

CREATE EXTENSION pg_text_semver;

Usage

• Source: GitHub repo, README
• pg_text_semver implements Semantic Versioning 2.0.0 on top of PostgreSQL text, using a semver domain and related helper types/functions.

CREATE EXTENSION pg_text_semver;

Core Workflow

The README highlights these capabilities:

• compare semver values with the usual comparison operators
• call semver_cmp(semver, semver) directly
• validate and inspect version strings with semver_regexp()
• cast parsed values to semver_parsed for sorting and indexing
• use semver_prerelease for prerelease validation and comparison

Examples

The upstream README points users to the test__pg_text_semver() procedure for concrete examples of the types, operators, and functions. It also notes that the extension ships a separate semver_parsed type that can be serialized back to semver or text.

Notes

The README contrasts this project with C-based semver extensions: pg_text_semver stays on text-backed domains and focuses on a simple, spec-oriented implementation.