pg_ulid

Universally Unique Lexicographically Sortable Identifier (ULID) for PostgreSQL

Experimental PostgreSQL extension for generating ULIDs.

Install

You need to have go and compiler (clang/gcc) installed on your system.

$ git clone https://github.com/icyberon/pg_ulid
$ cd pg_ulid
$ make
$ sudo make install

This will build and install the extension.

CREATE EXTENSION pg_ulid;

Usage

Now you can start generating ULIDs from PostgreSQL by calling ulid. Function returns TEXT

SELECT ulid(); -- 01C1P15MBWYBWDG2WYRG08VCFR
SELECT pg_typeof(ulid()); -- text

Todo

• [ ] Add binary support
• [ ] Add tests

Credits

All credits go to ulid and plgo