pg_ulid

December 19, 2017 ยท View on GitHub

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