uri

pg_uri : URI Data type for PostgreSQL

Overview

ID Extension Package Version Category License Language
3840
uri
pg_uri
1.20151224
TYPE
PostgreSQL
C
Attribute Has Binary Has Library Need Load Has DDL Relocatable Trusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
prefix
semver
unit
pgpdf
pglite_fusion
md5hash
asn1oid
roaringbitmap

+int flag

Packages

Type Repo Version PG Major Compatibility Package Pattern Dependencies
EXT
PIGSTY
1.20151224
18
17
16
15
14
13
pg_uri -
RPM
PIGSTY
1.20151224
18
17
16
15
14
13
pg_uri_$v* -
DEB
PIGSTY
1.20151224
18
17
16
15
14
13
postgresql-$v-pg-uri -
Linux / PG PG18 PG17 PG16 PG15 PG14 PG13
el8.x86_64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
el8.aarch64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
el9.x86_64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
el9.aarch64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
el10.x86_64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
el10.aarch64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
d12.x86_64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
d12.aarch64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
d13.x86_64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
d13.aarch64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
u22.x86_64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
u22.aarch64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
u24.x86_64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
u24.aarch64
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
PIGSTY 1.20151224
Package Version OS ORG SIZE File URL
pg_uri_18 1.20151224 el8.x86_64 pigsty 19.2 KiB pg_uri_18-1.20151224-1PIGSTY.el8.x86_64.rpm
pg_uri_18 1.20151224 el8.aarch64 pigsty 18.9 KiB pg_uri_18-1.20151224-1PIGSTY.el8.aarch64.rpm
pg_uri_18 1.20151224 el9.x86_64 pigsty 18.9 KiB pg_uri_18-1.20151224-1PIGSTY.el9.x86_64.rpm
pg_uri_18 1.20151224 el9.aarch64 pigsty 18.5 KiB pg_uri_18-1.20151224-1PIGSTY.el9.aarch64.rpm
pg_uri_18 1.20151224 el10.x86_64 pigsty 19.0 KiB pg_uri_18-1.20151224-1PIGSTY.el10.x86_64.rpm
pg_uri_18 1.20151224 el10.aarch64 pigsty 18.7 KiB pg_uri_18-1.20151224-1PIGSTY.el10.aarch64.rpm
postgresql-18-pg-uri 1.20151224 d12.x86_64 pigsty 21.6 KiB postgresql-18-pg-uri_1.20151224-1PIGSTY~bookworm_amd64.deb
postgresql-18-pg-uri 1.20151224 d12.aarch64 pigsty 21.3 KiB postgresql-18-pg-uri_1.20151224-1PIGSTY~bookworm_arm64.deb
postgresql-18-pg-uri 1.20151224 d13.x86_64 pigsty 21.7 KiB postgresql-18-pg-uri_1.20151224-1PIGSTY~trixie_amd64.deb
postgresql-18-pg-uri 1.20151224 d13.aarch64 pigsty 21.4 KiB postgresql-18-pg-uri_1.20151224-1PIGSTY~trixie_arm64.deb
postgresql-18-pg-uri 1.20151224 u22.x86_64 pigsty 22.8 KiB postgresql-18-pg-uri_1.20151224-1PIGSTY~jammy_amd64.deb
postgresql-18-pg-uri 1.20151224 u22.aarch64 pigsty 22.4 KiB postgresql-18-pg-uri_1.20151224-1PIGSTY~jammy_arm64.deb
postgresql-18-pg-uri 1.20151224 u24.x86_64 pigsty 22.7 KiB postgresql-18-pg-uri_1.20151224-1PIGSTY~noble_amd64.deb
postgresql-18-pg-uri 1.20151224 u24.aarch64 pigsty 22.4 KiB postgresql-18-pg-uri_1.20151224-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_uri_17 1.20151224 el8.x86_64 pigsty 19.2 KiB pg_uri_17-1.20151224-1PIGSTY.el8.x86_64.rpm
pg_uri_17 1.20151224 el8.aarch64 pigsty 18.9 KiB pg_uri_17-1.20151224-1PIGSTY.el8.aarch64.rpm
pg_uri_17 1.20151224 el9.x86_64 pigsty 18.8 KiB pg_uri_17-1.20151224-1PIGSTY.el9.x86_64.rpm
pg_uri_17 1.20151224 el9.aarch64 pigsty 18.5 KiB pg_uri_17-1.20151224-1PIGSTY.el9.aarch64.rpm
pg_uri_17 1.20151224 el10.x86_64 pigsty 18.8 KiB pg_uri_17-1.20151224-1PIGSTY.el10.x86_64.rpm
pg_uri_17 1.20151224 el10.aarch64 pigsty 18.7 KiB pg_uri_17-1.20151224-1PIGSTY.el10.aarch64.rpm
postgresql-17-pg-uri 1.20151224 d12.x86_64 pigsty 21.5 KiB postgresql-17-pg-uri_1.20151224-1PIGSTY~bookworm_amd64.deb
postgresql-17-pg-uri 1.20151224 d12.aarch64 pigsty 21.4 KiB postgresql-17-pg-uri_1.20151224-1PIGSTY~bookworm_arm64.deb
postgresql-17-pg-uri 1.20151224 d13.x86_64 pigsty 21.8 KiB postgresql-17-pg-uri_1.20151224-1PIGSTY~trixie_amd64.deb
postgresql-17-pg-uri 1.20151224 d13.aarch64 pigsty 21.4 KiB postgresql-17-pg-uri_1.20151224-1PIGSTY~trixie_arm64.deb
postgresql-17-pg-uri 1.20151224 u22.x86_64 pigsty 23.1 KiB postgresql-17-pg-uri_1.20151224-1PIGSTY~jammy_amd64.deb
postgresql-17-pg-uri 1.20151224 u22.aarch64 pigsty 23.0 KiB postgresql-17-pg-uri_1.20151224-1PIGSTY~jammy_arm64.deb
postgresql-17-pg-uri 1.20151224 u24.x86_64 pigsty 22.6 KiB postgresql-17-pg-uri_1.20151224-1PIGSTY~noble_amd64.deb
postgresql-17-pg-uri 1.20151224 u24.aarch64 pigsty 22.4 KiB postgresql-17-pg-uri_1.20151224-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_uri_16 1.20151224 el8.x86_64 pigsty 19.2 KiB pg_uri_16-1.20151224-1PIGSTY.el8.x86_64.rpm
pg_uri_16 1.20151224 el8.aarch64 pigsty 18.9 KiB pg_uri_16-1.20151224-1PIGSTY.el8.aarch64.rpm
pg_uri_16 1.20151224 el9.x86_64 pigsty 18.8 KiB pg_uri_16-1.20151224-1PIGSTY.el9.x86_64.rpm
pg_uri_16 1.20151224 el9.aarch64 pigsty 18.5 KiB pg_uri_16-1.20151224-1PIGSTY.el9.aarch64.rpm
pg_uri_16 1.20151224 el10.x86_64 pigsty 18.8 KiB pg_uri_16-1.20151224-1PIGSTY.el10.x86_64.rpm
pg_uri_16 1.20151224 el10.aarch64 pigsty 18.7 KiB pg_uri_16-1.20151224-1PIGSTY.el10.aarch64.rpm
postgresql-16-pg-uri 1.20151224 d12.x86_64 pigsty 21.5 KiB postgresql-16-pg-uri_1.20151224-1PIGSTY~bookworm_amd64.deb
postgresql-16-pg-uri 1.20151224 d12.aarch64 pigsty 21.4 KiB postgresql-16-pg-uri_1.20151224-1PIGSTY~bookworm_arm64.deb
postgresql-16-pg-uri 1.20151224 d13.x86_64 pigsty 21.7 KiB postgresql-16-pg-uri_1.20151224-1PIGSTY~trixie_amd64.deb
postgresql-16-pg-uri 1.20151224 d13.aarch64 pigsty 21.5 KiB postgresql-16-pg-uri_1.20151224-1PIGSTY~trixie_arm64.deb
postgresql-16-pg-uri 1.20151224 u22.x86_64 pigsty 23.1 KiB postgresql-16-pg-uri_1.20151224-1PIGSTY~jammy_amd64.deb
postgresql-16-pg-uri 1.20151224 u22.aarch64 pigsty 23.0 KiB postgresql-16-pg-uri_1.20151224-1PIGSTY~jammy_arm64.deb
postgresql-16-pg-uri 1.20151224 u24.x86_64 pigsty 22.6 KiB postgresql-16-pg-uri_1.20151224-1PIGSTY~noble_amd64.deb
postgresql-16-pg-uri 1.20151224 u24.aarch64 pigsty 22.4 KiB postgresql-16-pg-uri_1.20151224-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_uri_15 1.20151224 el8.x86_64 pigsty 19.2 KiB pg_uri_15-1.20151224-1PIGSTY.el8.x86_64.rpm
pg_uri_15 1.20151224 el8.aarch64 pigsty 18.9 KiB pg_uri_15-1.20151224-1PIGSTY.el8.aarch64.rpm
pg_uri_15 1.20151224 el9.x86_64 pigsty 18.8 KiB pg_uri_15-1.20151224-1PIGSTY.el9.x86_64.rpm
pg_uri_15 1.20151224 el9.aarch64 pigsty 18.5 KiB pg_uri_15-1.20151224-1PIGSTY.el9.aarch64.rpm
pg_uri_15 1.20151224 el10.x86_64 pigsty 18.8 KiB pg_uri_15-1.20151224-1PIGSTY.el10.x86_64.rpm
pg_uri_15 1.20151224 el10.aarch64 pigsty 18.7 KiB pg_uri_15-1.20151224-1PIGSTY.el10.aarch64.rpm
postgresql-15-pg-uri 1.20151224 d12.x86_64 pigsty 21.8 KiB postgresql-15-pg-uri_1.20151224-1PIGSTY~bookworm_amd64.deb
postgresql-15-pg-uri 1.20151224 d12.aarch64 pigsty 21.2 KiB postgresql-15-pg-uri_1.20151224-1PIGSTY~bookworm_arm64.deb
postgresql-15-pg-uri 1.20151224 d13.x86_64 pigsty 21.8 KiB postgresql-15-pg-uri_1.20151224-1PIGSTY~trixie_amd64.deb
postgresql-15-pg-uri 1.20151224 d13.aarch64 pigsty 21.3 KiB postgresql-15-pg-uri_1.20151224-1PIGSTY~trixie_arm64.deb
postgresql-15-pg-uri 1.20151224 u22.x86_64 pigsty 23.1 KiB postgresql-15-pg-uri_1.20151224-1PIGSTY~jammy_amd64.deb
postgresql-15-pg-uri 1.20151224 u22.aarch64 pigsty 23.0 KiB postgresql-15-pg-uri_1.20151224-1PIGSTY~jammy_arm64.deb
postgresql-15-pg-uri 1.20151224 u24.x86_64 pigsty 22.6 KiB postgresql-15-pg-uri_1.20151224-1PIGSTY~noble_amd64.deb
postgresql-15-pg-uri 1.20151224 u24.aarch64 pigsty 22.2 KiB postgresql-15-pg-uri_1.20151224-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_uri_14 1.20151224 el8.x86_64 pigsty 19.1 KiB pg_uri_14-1.20151224-1PIGSTY.el8.x86_64.rpm
pg_uri_14 1.20151224 el8.aarch64 pigsty 18.9 KiB pg_uri_14-1.20151224-1PIGSTY.el8.aarch64.rpm
pg_uri_14 1.20151224 el9.x86_64 pigsty 18.8 KiB pg_uri_14-1.20151224-1PIGSTY.el9.x86_64.rpm
pg_uri_14 1.20151224 el9.aarch64 pigsty 18.5 KiB pg_uri_14-1.20151224-1PIGSTY.el9.aarch64.rpm
pg_uri_14 1.20151224 el10.x86_64 pigsty 18.8 KiB pg_uri_14-1.20151224-1PIGSTY.el10.x86_64.rpm
pg_uri_14 1.20151224 el10.aarch64 pigsty 18.7 KiB pg_uri_14-1.20151224-1PIGSTY.el10.aarch64.rpm
postgresql-14-pg-uri 1.20151224 d12.x86_64 pigsty 21.8 KiB postgresql-14-pg-uri_1.20151224-1PIGSTY~bookworm_amd64.deb
postgresql-14-pg-uri 1.20151224 d12.aarch64 pigsty 21.2 KiB postgresql-14-pg-uri_1.20151224-1PIGSTY~bookworm_arm64.deb
postgresql-14-pg-uri 1.20151224 d13.x86_64 pigsty 21.7 KiB postgresql-14-pg-uri_1.20151224-1PIGSTY~trixie_amd64.deb
postgresql-14-pg-uri 1.20151224 d13.aarch64 pigsty 21.3 KiB postgresql-14-pg-uri_1.20151224-1PIGSTY~trixie_arm64.deb
postgresql-14-pg-uri 1.20151224 u22.x86_64 pigsty 23.1 KiB postgresql-14-pg-uri_1.20151224-1PIGSTY~jammy_amd64.deb
postgresql-14-pg-uri 1.20151224 u22.aarch64 pigsty 22.9 KiB postgresql-14-pg-uri_1.20151224-1PIGSTY~jammy_arm64.deb
postgresql-14-pg-uri 1.20151224 u24.x86_64 pigsty 22.6 KiB postgresql-14-pg-uri_1.20151224-1PIGSTY~noble_amd64.deb
postgresql-14-pg-uri 1.20151224 u24.aarch64 pigsty 22.2 KiB postgresql-14-pg-uri_1.20151224-1PIGSTY~noble_arm64.deb
Package Version OS ORG SIZE File URL
pg_uri_13 1.20151224 el8.x86_64 pigsty 19.1 KiB pg_uri_13-1.20151224-1PIGSTY.el8.x86_64.rpm
pg_uri_13 1.20151224 el8.aarch64 pigsty 18.9 KiB pg_uri_13-1.20151224-1PIGSTY.el8.aarch64.rpm
pg_uri_13 1.20151224 el9.x86_64 pigsty 18.7 KiB pg_uri_13-1.20151224-1PIGSTY.el9.x86_64.rpm
pg_uri_13 1.20151224 el9.aarch64 pigsty 18.5 KiB pg_uri_13-1.20151224-1PIGSTY.el9.aarch64.rpm
pg_uri_13 1.20151224 el10.x86_64 pigsty 18.9 KiB pg_uri_13-1.20151224-1PIGSTY.el10.x86_64.rpm
pg_uri_13 1.20151224 el10.aarch64 pigsty 18.7 KiB pg_uri_13-1.20151224-1PIGSTY.el10.aarch64.rpm
postgresql-13-pg-uri 1.20151224 d12.x86_64 pigsty 21.5 KiB postgresql-13-pg-uri_1.20151224-1PIGSTY~bookworm_amd64.deb
postgresql-13-pg-uri 1.20151224 d12.aarch64 pigsty 21.1 KiB postgresql-13-pg-uri_1.20151224-1PIGSTY~bookworm_arm64.deb
postgresql-13-pg-uri 1.20151224 d13.x86_64 pigsty 21.4 KiB postgresql-13-pg-uri_1.20151224-1PIGSTY~trixie_amd64.deb
postgresql-13-pg-uri 1.20151224 d13.aarch64 pigsty 21.3 KiB postgresql-13-pg-uri_1.20151224-1PIGSTY~trixie_arm64.deb
postgresql-13-pg-uri 1.20151224 u22.x86_64 pigsty 22.9 KiB postgresql-13-pg-uri_1.20151224-1PIGSTY~jammy_amd64.deb
postgresql-13-pg-uri 1.20151224 u22.aarch64 pigsty 22.7 KiB postgresql-13-pg-uri_1.20151224-1PIGSTY~jammy_arm64.deb
postgresql-13-pg-uri 1.20151224 u24.x86_64 pigsty 22.2 KiB postgresql-13-pg-uri_1.20151224-1PIGSTY~noble_amd64.deb
postgresql-13-pg-uri 1.20151224 u24.aarch64 pigsty 22.1 KiB postgresql-13-pg-uri_1.20151224-1PIGSTY~noble_arm64.deb

Source

pig build pkg pg_uri;		# 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_uri;		# install via package name, for the active PG version
pig install uri;		# install by extension name, for the current active PG version

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

Create this extension with:

CREATE EXTENSION uri;
Last updated on