Extensions
typeid

typeid

pg_typeid : Allows to use TypeIDs in Postgres natively

Overview

ID Extension Package Version Category License Language
4580
typeid
pg_typeid
 0.3.0
FUNC
MIT
Rust
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d--
No
Yes
No
Yes
no
no
Relationships
See Also
pg_idkit
pg_uuidv7
pgx_ulid
uuid-ossp
pg_hashids
permuteseq

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PIGSTY
 0.3.0
18
17
16
15
14
13
 pg_typeid -
RPM
PIGSTY
 0.3.0
18
17
16
15
14
13
 pg_typeid_$v -
DEB
PIGSTY
 0.3.0
18
17
16
15
14
13
 postgresql-$v-typeid -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
el8.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
el9.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
el9.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
el10.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
el10.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
d12.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
d12.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
d13.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
d13.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
u22.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
u22.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
u24.x86_64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
u24.aarch64
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
PIGSTY 0.3.0
Package Version OS ORG SIZE File URL
pg_typeid_18 0.3.0 el8.x86_64 pigsty 395.1 KiB pg_typeid_18-0.3.0-1PIGSTY.el8.x86_64.rpm
pg_typeid_18 0.3.0 el8.aarch64 pigsty 281.9 KiB pg_typeid_18-0.3.0-1PIGSTY.el8.aarch64.rpm
pg_typeid_18 0.3.0 el9.x86_64 pigsty 411.4 KiB pg_typeid_18-0.3.0-1PIGSTY.el9.x86_64.rpm
pg_typeid_18 0.3.0 el9.aarch64 pigsty 301.7 KiB pg_typeid_18-0.3.0-1PIGSTY.el9.aarch64.rpm
pg_typeid_18 0.3.0 el10.x86_64 pigsty 411.4 KiB pg_typeid_18-0.3.0-1PIGSTY.el10.x86_64.rpm
pg_typeid_18 0.3.0 el10.aarch64 pigsty 301.6 KiB pg_typeid_18-0.3.0-1PIGSTY.el10.aarch64.rpm
postgresql-18-typeid 0.3.0 d12.x86_64 pigsty 326.8 KiB postgresql-18-typeid_0.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-18-typeid 0.3.0 d12.aarch64 pigsty 219.4 KiB postgresql-18-typeid_0.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-18-typeid 0.3.0 d13.x86_64 pigsty 326.5 KiB postgresql-18-typeid_0.3.0-1PIGSTY~trixie_amd64.deb
postgresql-18-typeid 0.3.0 d13.aarch64 pigsty 219.3 KiB postgresql-18-typeid_0.3.0-1PIGSTY~trixie_arm64.deb
postgresql-18-typeid 0.3.0 u22.x86_64 pigsty 367.2 KiB postgresql-18-typeid_0.3.0-1PIGSTY~jammy_amd64.deb
postgresql-18-typeid 0.3.0 u22.aarch64 pigsty 255.6 KiB postgresql-18-typeid_0.3.0-1PIGSTY~jammy_arm64.deb
postgresql-18-typeid 0.3.0 u24.x86_64 pigsty 363.6 KiB postgresql-18-typeid_0.3.0-1PIGSTY~noble_amd64.deb
postgresql-18-typeid 0.3.0 u24.aarch64 pigsty 254.0 KiB postgresql-18-typeid_0.3.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_typeid_17 0.3.0 el8.x86_64 pigsty 394.8 KiB pg_typeid_17-0.3.0-1PIGSTY.el8.x86_64.rpm
pg_typeid_17 0.3.0 el8.aarch64 pigsty 282.1 KiB pg_typeid_17-0.3.0-1PIGSTY.el8.aarch64.rpm
pg_typeid_17 0.3.0 el9.x86_64 pigsty 411.0 KiB pg_typeid_17-0.3.0-1PIGSTY.el9.x86_64.rpm
pg_typeid_17 0.3.0 el9.aarch64 pigsty 301.9 KiB pg_typeid_17-0.3.0-1PIGSTY.el9.aarch64.rpm
pg_typeid_17 0.3.0 el10.x86_64 pigsty 411.0 KiB pg_typeid_17-0.3.0-1PIGSTY.el10.x86_64.rpm
pg_typeid_17 0.3.0 el10.aarch64 pigsty 301.6 KiB pg_typeid_17-0.3.0-1PIGSTY.el10.aarch64.rpm
postgresql-17-typeid 0.3.0 d12.x86_64 pigsty 326.1 KiB postgresql-17-typeid_0.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-17-typeid 0.3.0 d12.aarch64 pigsty 219.5 KiB postgresql-17-typeid_0.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-17-typeid 0.3.0 d13.x86_64 pigsty 326.5 KiB postgresql-17-typeid_0.3.0-1PIGSTY~trixie_amd64.deb
postgresql-17-typeid 0.3.0 d13.aarch64 pigsty 219.3 KiB postgresql-17-typeid_0.3.0-1PIGSTY~trixie_arm64.deb
postgresql-17-typeid 0.3.0 u22.x86_64 pigsty 366.8 KiB postgresql-17-typeid_0.3.0-1PIGSTY~jammy_amd64.deb
postgresql-17-typeid 0.3.0 u22.aarch64 pigsty 255.7 KiB postgresql-17-typeid_0.3.0-1PIGSTY~jammy_arm64.deb
postgresql-17-typeid 0.3.0 u24.x86_64 pigsty 363.4 KiB postgresql-17-typeid_0.3.0-1PIGSTY~noble_amd64.deb
postgresql-17-typeid 0.3.0 u24.aarch64 pigsty 254.2 KiB postgresql-17-typeid_0.3.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_typeid_16 0.3.0 el8.x86_64 pigsty 395.1 KiB pg_typeid_16-0.3.0-1PIGSTY.el8.x86_64.rpm
pg_typeid_16 0.3.0 el8.aarch64 pigsty 281.9 KiB pg_typeid_16-0.3.0-1PIGSTY.el8.aarch64.rpm
pg_typeid_16 0.3.0 el9.x86_64 pigsty 411.5 KiB pg_typeid_16-0.3.0-1PIGSTY.el9.x86_64.rpm
pg_typeid_16 0.3.0 el9.aarch64 pigsty 301.8 KiB pg_typeid_16-0.3.0-1PIGSTY.el9.aarch64.rpm
pg_typeid_16 0.3.0 el10.x86_64 pigsty 411.5 KiB pg_typeid_16-0.3.0-1PIGSTY.el10.x86_64.rpm
pg_typeid_16 0.3.0 el10.aarch64 pigsty 301.6 KiB pg_typeid_16-0.3.0-1PIGSTY.el10.aarch64.rpm
postgresql-16-typeid 0.3.0 d12.x86_64 pigsty 326.5 KiB postgresql-16-typeid_0.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-16-typeid 0.3.0 d12.aarch64 pigsty 219.4 KiB postgresql-16-typeid_0.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-16-typeid 0.3.0 d13.x86_64 pigsty 326.7 KiB postgresql-16-typeid_0.3.0-1PIGSTY~trixie_amd64.deb
postgresql-16-typeid 0.3.0 d13.aarch64 pigsty 219.3 KiB postgresql-16-typeid_0.3.0-1PIGSTY~trixie_arm64.deb
postgresql-16-typeid 0.3.0 u22.x86_64 pigsty 367.2 KiB postgresql-16-typeid_0.3.0-1PIGSTY~jammy_amd64.deb
postgresql-16-typeid 0.3.0 u22.aarch64 pigsty 255.5 KiB postgresql-16-typeid_0.3.0-1PIGSTY~jammy_arm64.deb
postgresql-16-typeid 0.3.0 u24.x86_64 pigsty 363.5 KiB postgresql-16-typeid_0.3.0-1PIGSTY~noble_amd64.deb
postgresql-16-typeid 0.3.0 u24.aarch64 pigsty 254.0 KiB postgresql-16-typeid_0.3.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_typeid_15 0.3.0 el8.x86_64 pigsty 395.0 KiB pg_typeid_15-0.3.0-1PIGSTY.el8.x86_64.rpm
pg_typeid_15 0.3.0 el8.aarch64 pigsty 282.2 KiB pg_typeid_15-0.3.0-1PIGSTY.el8.aarch64.rpm
pg_typeid_15 0.3.0 el9.x86_64 pigsty 411.0 KiB pg_typeid_15-0.3.0-1PIGSTY.el9.x86_64.rpm
pg_typeid_15 0.3.0 el9.aarch64 pigsty 302.0 KiB pg_typeid_15-0.3.0-1PIGSTY.el9.aarch64.rpm
pg_typeid_15 0.3.0 el10.x86_64 pigsty 411.0 KiB pg_typeid_15-0.3.0-1PIGSTY.el10.x86_64.rpm
pg_typeid_15 0.3.0 el10.aarch64 pigsty 301.6 KiB pg_typeid_15-0.3.0-1PIGSTY.el10.aarch64.rpm
postgresql-15-typeid 0.3.0 d12.x86_64 pigsty 326.8 KiB postgresql-15-typeid_0.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-15-typeid 0.3.0 d12.aarch64 pigsty 219.5 KiB postgresql-15-typeid_0.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-15-typeid 0.3.0 d13.x86_64 pigsty 326.6 KiB postgresql-15-typeid_0.3.0-1PIGSTY~trixie_amd64.deb
postgresql-15-typeid 0.3.0 d13.aarch64 pigsty 219.4 KiB postgresql-15-typeid_0.3.0-1PIGSTY~trixie_arm64.deb
postgresql-15-typeid 0.3.0 u22.x86_64 pigsty 367.0 KiB postgresql-15-typeid_0.3.0-1PIGSTY~jammy_amd64.deb
postgresql-15-typeid 0.3.0 u22.aarch64 pigsty 255.7 KiB postgresql-15-typeid_0.3.0-1PIGSTY~jammy_arm64.deb
postgresql-15-typeid 0.3.0 u24.x86_64 pigsty 363.4 KiB postgresql-15-typeid_0.3.0-1PIGSTY~noble_amd64.deb
postgresql-15-typeid 0.3.0 u24.aarch64 pigsty 254.2 KiB postgresql-15-typeid_0.3.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_typeid_14 0.3.0 el8.x86_64 pigsty 394.9 KiB pg_typeid_14-0.3.0-1PIGSTY.el8.x86_64.rpm
pg_typeid_14 0.3.0 el8.aarch64 pigsty 282.1 KiB pg_typeid_14-0.3.0-1PIGSTY.el8.aarch64.rpm
pg_typeid_14 0.3.0 el9.x86_64 pigsty 411.1 KiB pg_typeid_14-0.3.0-1PIGSTY.el9.x86_64.rpm
pg_typeid_14 0.3.0 el9.aarch64 pigsty 302.0 KiB pg_typeid_14-0.3.0-1PIGSTY.el9.aarch64.rpm
pg_typeid_14 0.3.0 el10.x86_64 pigsty 410.8 KiB pg_typeid_14-0.3.0-1PIGSTY.el10.x86_64.rpm
pg_typeid_14 0.3.0 el10.aarch64 pigsty 301.6 KiB pg_typeid_14-0.3.0-1PIGSTY.el10.aarch64.rpm
postgresql-14-typeid 0.3.0 d12.x86_64 pigsty 326.7 KiB postgresql-14-typeid_0.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-14-typeid 0.3.0 d12.aarch64 pigsty 219.4 KiB postgresql-14-typeid_0.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-14-typeid 0.3.0 d13.x86_64 pigsty 326.5 KiB postgresql-14-typeid_0.3.0-1PIGSTY~trixie_amd64.deb
postgresql-14-typeid 0.3.0 d13.aarch64 pigsty 219.4 KiB postgresql-14-typeid_0.3.0-1PIGSTY~trixie_arm64.deb
postgresql-14-typeid 0.3.0 u22.x86_64 pigsty 366.7 KiB postgresql-14-typeid_0.3.0-1PIGSTY~jammy_amd64.deb
postgresql-14-typeid 0.3.0 u22.aarch64 pigsty 256.3 KiB postgresql-14-typeid_0.3.0-1PIGSTY~jammy_arm64.deb
postgresql-14-typeid 0.3.0 u24.x86_64 pigsty 363.6 KiB postgresql-14-typeid_0.3.0-1PIGSTY~noble_amd64.deb
postgresql-14-typeid 0.3.0 u24.aarch64 pigsty 253.4 KiB postgresql-14-typeid_0.3.0-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_typeid_13 0.3.0 el8.x86_64 pigsty 395.2 KiB pg_typeid_13-0.3.0-1PIGSTY.el8.x86_64.rpm
pg_typeid_13 0.3.0 el8.aarch64 pigsty 282.2 KiB pg_typeid_13-0.3.0-1PIGSTY.el8.aarch64.rpm
pg_typeid_13 0.3.0 el9.x86_64 pigsty 411.6 KiB pg_typeid_13-0.3.0-1PIGSTY.el9.x86_64.rpm
pg_typeid_13 0.3.0 el9.aarch64 pigsty 301.8 KiB pg_typeid_13-0.3.0-1PIGSTY.el9.aarch64.rpm
pg_typeid_13 0.3.0 el10.x86_64 pigsty 411.5 KiB pg_typeid_13-0.3.0-1PIGSTY.el10.x86_64.rpm
pg_typeid_13 0.3.0 el10.aarch64 pigsty 301.7 KiB pg_typeid_13-0.3.0-1PIGSTY.el10.aarch64.rpm
postgresql-13-typeid 0.3.0 d12.x86_64 pigsty 326.5 KiB postgresql-13-typeid_0.3.0-1PIGSTY~bookworm_amd64.deb
postgresql-13-typeid 0.3.0 d12.aarch64 pigsty 219.7 KiB postgresql-13-typeid_0.3.0-1PIGSTY~bookworm_arm64.deb
postgresql-13-typeid 0.3.0 d13.x86_64 pigsty 326.7 KiB postgresql-13-typeid_0.3.0-1PIGSTY~trixie_amd64.deb
postgresql-13-typeid 0.3.0 d13.aarch64 pigsty 219.5 KiB postgresql-13-typeid_0.3.0-1PIGSTY~trixie_arm64.deb
postgresql-13-typeid 0.3.0 u22.x86_64 pigsty 367.2 KiB postgresql-13-typeid_0.3.0-1PIGSTY~jammy_amd64.deb
postgresql-13-typeid 0.3.0 u22.aarch64 pigsty 255.7 KiB postgresql-13-typeid_0.3.0-1PIGSTY~jammy_arm64.deb
postgresql-13-typeid 0.3.0 u24.x86_64 pigsty 364.1 KiB postgresql-13-typeid_0.3.0-1PIGSTY~noble_amd64.deb
postgresql-13-typeid 0.3.0 u24.aarch64 pigsty 253.8 KiB postgresql-13-typeid_0.3.0-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/blitss/typeid-postgres
 Source Tarball
typeid-postgres-0.3.0.tar.gz
 
pig build pkg pg_typeid;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

pig install pg_typeid;		# install via package name, for the active PG version
pig install typeid;		# install by extension name, for the current active PG version

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

Create this extension with:

CREATE EXTENSION typeid;
Last updated on
sequential_uuidstopn