select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Functions and aggregates

pg_sqids

Encode numbers as short URL-safe Sqids and decode them in PostgreSQL

pgext.cloud · Source code · Website · Documentation · License text · Control file

Overview

Packagepg_sqids
Version0.1.0
PostgreSQL versions13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeStandard
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedYes
RelocatableNo
Stars102
Latest commit2026-06-12
Catalogue updated2026-08-30

Related extensions

See also

emojigresql🐘 EmojigreSQL: A pure SQL PostgreSQL extension to encode/decode binary data (bytea) and text into colorful emoji sequences! ✨ Includes basic checksum validation.
urlSQL and PL/pgSQL types and helper functions for URL parsing, encoding, decoding, and query-string key/value handling.
compressC/C++ functions to compress text into Base64-encoded ZIP archives and extract text from them.
gzipgzip and gunzip functions.
zstdZstandard compression algorithm implementation in PostgreSQL
pg_polylineFast Google Encoded Polyline encoding & decoding for postgres
pg_deltaxFast time-series extension for PostgreSQL
zsonDictionary-trained compressed JSONB-compatible type with transparent casts and JSONB operators.