asn1oid

asn1oid extension

Overview

Package	Version	Category	License	Language
`asn1oid`	`1.6`	TYPE	GPL-3.0	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
3620	`asn1oid`	No	Yes	No	Yes	No	Yes	-

Related	`isn` `uri` `country` `emailaddr` `pg_html5_email_address`

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	MIXED	`1.6`	1817161514	`asn1oid`	-
RPM	PIGSTY	`1.6`	1817161514	`asn1oid_$v`	-
DEB	PGDG	`1.6`	1817161514	`postgresql-$v-asn1oid`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 1.6 el8.x86_64.pg18 : asn1oid_18 asn1oid_18-1.6-2PGSTY.el8.x86_64.rpm PIGSTY · 1.6 · 13.6KiB	PIGSTY 1.6 el8.x86_64.pg17 : asn1oid_17 asn1oid_17-1.6-2PGSTY.el8.x86_64.rpm PIGSTY · 1.6 · 13.6KiB	PIGSTY 1.6 el8.x86_64.pg16 : asn1oid_16 asn1oid_16-1.6-2PGSTY.el8.x86_64.rpm PIGSTY · 1.6 · 13.6KiB	PIGSTY 1.6 el8.x86_64.pg15 : asn1oid_15 asn1oid_15-1.6-2PGSTY.el8.x86_64.rpm PIGSTY · 1.6 · 13.6KiB	PIGSTY 1.6 el8.x86_64.pg14 : asn1oid_14 asn1oid_14-1.6-2PGSTY.el8.x86_64.rpm PIGSTY · 1.6 · 13.6KiB
el8.aarch64	PIGSTY 1.6 el8.aarch64.pg18 : asn1oid_18 asn1oid_18-1.6-2PGSTY.el8.aarch64.rpm PIGSTY · 1.6 · 13.8KiB	PIGSTY 1.6 el8.aarch64.pg17 : asn1oid_17 asn1oid_17-1.6-2PGSTY.el8.aarch64.rpm PIGSTY · 1.6 · 13.8KiB	PIGSTY 1.6 el8.aarch64.pg16 : asn1oid_16 asn1oid_16-1.6-2PGSTY.el8.aarch64.rpm PIGSTY · 1.6 · 13.8KiB	PIGSTY 1.6 el8.aarch64.pg15 : asn1oid_15 asn1oid_15-1.6-2PGSTY.el8.aarch64.rpm PIGSTY · 1.6 · 13.8KiB	PIGSTY 1.6 el8.aarch64.pg14 : asn1oid_14 asn1oid_14-1.6-2PGSTY.el8.aarch64.rpm PIGSTY · 1.6 · 13.7KiB
el9.x86_64	PIGSTY 1.6 el9.x86_64.pg18 : asn1oid_18 asn1oid_18-1.6-2PGSTY.el9.x86_64.rpm PIGSTY · 1.6 · 13.5KiB	PIGSTY 1.6 el9.x86_64.pg17 : asn1oid_17 asn1oid_17-1.6-2PGSTY.el9.x86_64.rpm PIGSTY · 1.6 · 13.5KiB	PIGSTY 1.6 el9.x86_64.pg16 : asn1oid_16 asn1oid_16-1.6-2PGSTY.el9.x86_64.rpm PIGSTY · 1.6 · 13.5KiB	PIGSTY 1.6 el9.x86_64.pg15 : asn1oid_15 asn1oid_15-1.6-2PGSTY.el9.x86_64.rpm PIGSTY · 1.6 · 13.5KiB	PIGSTY 1.6 el9.x86_64.pg14 : asn1oid_14 asn1oid_14-1.6-2PGSTY.el9.x86_64.rpm PIGSTY · 1.6 · 13.5KiB
el9.aarch64	PIGSTY 1.6 el9.aarch64.pg18 : asn1oid_18 asn1oid_18-1.6-2PGSTY.el9.aarch64.rpm PIGSTY · 1.6 · 13.5KiB	PIGSTY 1.6 el9.aarch64.pg17 : asn1oid_17 asn1oid_17-1.6-2PGSTY.el9.aarch64.rpm PIGSTY · 1.6 · 13.6KiB	PIGSTY 1.6 el9.aarch64.pg16 : asn1oid_16 asn1oid_16-1.6-2PGSTY.el9.aarch64.rpm PIGSTY · 1.6 · 13.6KiB	PIGSTY 1.6 el9.aarch64.pg15 : asn1oid_15 asn1oid_15-1.6-2PGSTY.el9.aarch64.rpm PIGSTY · 1.6 · 13.5KiB	PIGSTY 1.6 el9.aarch64.pg14 : asn1oid_14 asn1oid_14-1.6-2PGSTY.el9.aarch64.rpm PIGSTY · 1.6 · 13.6KiB
el10.x86_64	PIGSTY 1.6 el10.x86_64.pg18 : asn1oid_18 asn1oid_18-1.6-2PGSTY.el10.x86_64.rpm PIGSTY · 1.6 · 13.5KiB	PIGSTY 1.6 el10.x86_64.pg17 : asn1oid_17 asn1oid_17-1.6-2PGSTY.el10.x86_64.rpm PIGSTY · 1.6 · 13.5KiB	PIGSTY 1.6 el10.x86_64.pg16 : asn1oid_16 asn1oid_16-1.6-2PGSTY.el10.x86_64.rpm PIGSTY · 1.6 · 13.5KiB	PIGSTY 1.6 el10.x86_64.pg15 : asn1oid_15 asn1oid_15-1.6-2PGSTY.el10.x86_64.rpm PIGSTY · 1.6 · 13.6KiB	PIGSTY 1.6 el10.x86_64.pg14 : asn1oid_14 asn1oid_14-1.6-2PGSTY.el10.x86_64.rpm PIGSTY · 1.6 · 13.6KiB
el10.aarch64	PIGSTY 1.6 el10.aarch64.pg18 : asn1oid_18 asn1oid_18-1.6-2PGSTY.el10.aarch64.rpm PIGSTY · 1.6 · 13.7KiB	PIGSTY 1.6 el10.aarch64.pg17 : asn1oid_17 asn1oid_17-1.6-2PGSTY.el10.aarch64.rpm PIGSTY · 1.6 · 13.7KiB	PIGSTY 1.6 el10.aarch64.pg16 : asn1oid_16 asn1oid_16-1.6-2PGSTY.el10.aarch64.rpm PIGSTY · 1.6 · 13.7KiB	PIGSTY 1.6 el10.aarch64.pg15 : asn1oid_15 asn1oid_15-1.6-2PGSTY.el10.aarch64.rpm PIGSTY · 1.6 · 13.7KiB	PIGSTY 1.6 el10.aarch64.pg14 : asn1oid_14 asn1oid_14-1.6-2PGSTY.el10.aarch64.rpm PIGSTY · 1.6 · 13.7KiB
d12.x86_64	PGDG 1.6 d12.x86_64.pg18 : postgresql-18-asn1oid postgresql-18-asn1oid_1.6-3.pgdg12+1_amd64.deb PGDG · 1.6 · 12.8KiB	PGDG 1.6 d12.x86_64.pg17 : postgresql-17-asn1oid postgresql-17-asn1oid_1.6-3.pgdg12+1_amd64.deb PGDG · 1.6 · 12.8KiB	PGDG 1.6 d12.x86_64.pg16 : postgresql-16-asn1oid postgresql-16-asn1oid_1.6-3.pgdg12+1_amd64.deb PGDG · 1.6 · 12.8KiB	PGDG 1.6 d12.x86_64.pg15 : postgresql-15-asn1oid postgresql-15-asn1oid_1.6-3.pgdg12+1_amd64.deb PGDG · 1.6 · 12.8KiB	PGDG 1.6 d12.x86_64.pg14 : postgresql-14-asn1oid postgresql-14-asn1oid_1.6-3.pgdg12+1_amd64.deb PGDG · 1.6 · 12.8KiB
d12.aarch64	PGDG 1.6 d12.aarch64.pg18 : postgresql-18-asn1oid postgresql-18-asn1oid_1.6-3.pgdg12+1_arm64.deb PGDG · 1.6 · 12.9KiB	PGDG 1.6 d12.aarch64.pg17 : postgresql-17-asn1oid postgresql-17-asn1oid_1.6-3.pgdg12+1_arm64.deb PGDG · 1.6 · 12.8KiB	PGDG 1.6 d12.aarch64.pg16 : postgresql-16-asn1oid postgresql-16-asn1oid_1.6-3.pgdg12+1_arm64.deb PGDG · 1.6 · 12.8KiB	PGDG 1.6 d12.aarch64.pg15 : postgresql-15-asn1oid postgresql-15-asn1oid_1.6-3.pgdg12+1_arm64.deb PGDG · 1.6 · 12.8KiB	PGDG 1.6 d12.aarch64.pg14 : postgresql-14-asn1oid postgresql-14-asn1oid_1.6-3.pgdg12+1_arm64.deb PGDG · 1.6 · 12.8KiB
d13.x86_64	PGDG 1.6 d13.x86_64.pg18 : postgresql-18-asn1oid postgresql-18-asn1oid_1.6-3.pgdg13+1_amd64.deb PGDG · 1.6 · 12.8KiB	PGDG 1.6 d13.x86_64.pg17 : postgresql-17-asn1oid postgresql-17-asn1oid_1.6-3.pgdg13+1_amd64.deb PGDG · 1.6 · 12.7KiB	PGDG 1.6 d13.x86_64.pg16 : postgresql-16-asn1oid postgresql-16-asn1oid_1.6-3.pgdg13+1_amd64.deb PGDG · 1.6 · 12.7KiB	PGDG 1.6 d13.x86_64.pg15 : postgresql-15-asn1oid postgresql-15-asn1oid_1.6-3.pgdg13+1_amd64.deb PGDG · 1.6 · 12.8KiB	PGDG 1.6 d13.x86_64.pg14 : postgresql-14-asn1oid postgresql-14-asn1oid_1.6-3.pgdg13+1_amd64.deb PGDG · 1.6 · 12.8KiB
d13.aarch64	PGDG 1.6 d13.aarch64.pg18 : postgresql-18-asn1oid postgresql-18-asn1oid_1.6-3.pgdg13+1_arm64.deb PGDG · 1.6 · 13.0KiB	PGDG 1.6 d13.aarch64.pg17 : postgresql-17-asn1oid postgresql-17-asn1oid_1.6-3.pgdg13+1_arm64.deb PGDG · 1.6 · 12.9KiB	PGDG 1.6 d13.aarch64.pg16 : postgresql-16-asn1oid postgresql-16-asn1oid_1.6-3.pgdg13+1_arm64.deb PGDG · 1.6 · 12.9KiB	PGDG 1.6 d13.aarch64.pg15 : postgresql-15-asn1oid postgresql-15-asn1oid_1.6-3.pgdg13+1_arm64.deb PGDG · 1.6 · 12.9KiB	PGDG 1.6 d13.aarch64.pg14 : postgresql-14-asn1oid postgresql-14-asn1oid_1.6-3.pgdg13+1_arm64.deb PGDG · 1.6 · 12.9KiB
u22.x86_64	PGDG 1.6 u22.x86_64.pg18 : postgresql-18-asn1oid postgresql-18-asn1oid_1.6-3.pgdg22.04+1_amd64.deb PGDG · 1.6 · 13.1KiB	PGDG 1.6 u22.x86_64.pg17 : postgresql-17-asn1oid postgresql-17-asn1oid_1.6-3.pgdg22.04+1_amd64.deb PGDG · 1.6 · 13.4KiB	PGDG 1.6 u22.x86_64.pg16 : postgresql-16-asn1oid postgresql-16-asn1oid_1.6-3.pgdg22.04+1_amd64.deb PGDG · 1.6 · 13.4KiB	PGDG 1.6 u22.x86_64.pg15 : postgresql-15-asn1oid postgresql-15-asn1oid_1.6-3.pgdg22.04+1_amd64.deb PGDG · 1.6 · 13.4KiB	PGDG 1.6 u22.x86_64.pg14 : postgresql-14-asn1oid postgresql-14-asn1oid_1.6-3.pgdg22.04+1_amd64.deb PGDG · 1.6 · 13.4KiB
u22.aarch64	PGDG 1.6 u22.aarch64.pg18 : postgresql-18-asn1oid postgresql-18-asn1oid_1.6-3.pgdg22.04+1_arm64.deb PGDG · 1.6 · 13.0KiB	PGDG 1.6 u22.aarch64.pg17 : postgresql-17-asn1oid postgresql-17-asn1oid_1.6-3.pgdg22.04+1_arm64.deb PGDG · 1.6 · 13.3KiB	PGDG 1.6 u22.aarch64.pg16 : postgresql-16-asn1oid postgresql-16-asn1oid_1.6-3.pgdg22.04+1_arm64.deb PGDG · 1.6 · 13.3KiB	PGDG 1.6 u22.aarch64.pg15 : postgresql-15-asn1oid postgresql-15-asn1oid_1.6-3.pgdg22.04+1_arm64.deb PGDG · 1.6 · 13.3KiB	PGDG 1.6 u22.aarch64.pg14 : postgresql-14-asn1oid postgresql-14-asn1oid_1.6-3.pgdg22.04+1_arm64.deb PGDG · 1.6 · 13.3KiB
u24.x86_64	PGDG 1.6 u24.x86_64.pg18 : postgresql-18-asn1oid postgresql-18-asn1oid_1.6-3.pgdg24.04+1_amd64.deb PGDG · 1.6 · 12.9KiB	PGDG 1.6 u24.x86_64.pg17 : postgresql-17-asn1oid postgresql-17-asn1oid_1.6-3.pgdg24.04+1_amd64.deb PGDG · 1.6 · 12.9KiB	PGDG 1.6 u24.x86_64.pg16 : postgresql-16-asn1oid postgresql-16-asn1oid_1.6-3.pgdg24.04+1_amd64.deb PGDG · 1.6 · 12.9KiB	PGDG 1.6 u24.x86_64.pg15 : postgresql-15-asn1oid postgresql-15-asn1oid_1.6-3.pgdg24.04+1_amd64.deb PGDG · 1.6 · 12.9KiB	PGDG 1.6 u24.x86_64.pg14 : postgresql-14-asn1oid postgresql-14-asn1oid_1.6-3.pgdg24.04+1_amd64.deb PGDG · 1.6 · 12.8KiB
u24.aarch64	PGDG 1.6 u24.aarch64.pg18 : postgresql-18-asn1oid postgresql-18-asn1oid_1.6-3.pgdg24.04+1_arm64.deb PGDG · 1.6 · 13.1KiB	PGDG 1.6 u24.aarch64.pg17 : postgresql-17-asn1oid postgresql-17-asn1oid_1.6-3.pgdg24.04+1_arm64.deb PGDG · 1.6 · 13.0KiB	PGDG 1.6 u24.aarch64.pg16 : postgresql-16-asn1oid postgresql-16-asn1oid_1.6-3.pgdg24.04+1_arm64.deb PGDG · 1.6 · 12.9KiB	PGDG 1.6 u24.aarch64.pg15 : postgresql-15-asn1oid postgresql-15-asn1oid_1.6-3.pgdg24.04+1_arm64.deb PGDG · 1.6 · 13.0KiB	PGDG 1.6 u24.aarch64.pg14 : postgresql-14-asn1oid postgresql-14-asn1oid_1.6-3.pgdg24.04+1_arm64.deb PGDG · 1.6 · 13.0KiB
u26.x86_64	PGDG 1.6 u26.x86_64.pg18 : postgresql-18-asn1oid postgresql-18-asn1oid_1.6-3.pgdg26.04+1_amd64.deb PGDG · 1.6 · 13.0KiB	PGDG 1.6 u26.x86_64.pg17 : postgresql-17-asn1oid postgresql-17-asn1oid_1.6-3.pgdg26.04+1_amd64.deb PGDG · 1.6 · 13.0KiB	PGDG 1.6 u26.x86_64.pg16 : postgresql-16-asn1oid postgresql-16-asn1oid_1.6-3.pgdg26.04+1_amd64.deb PGDG · 1.6 · 13.0KiB	PGDG 1.6 u26.x86_64.pg15 : postgresql-15-asn1oid postgresql-15-asn1oid_1.6-3.pgdg26.04+1_amd64.deb PGDG · 1.6 · 13.0KiB	PGDG 1.6 u26.x86_64.pg14 : postgresql-14-asn1oid postgresql-14-asn1oid_1.6-3.pgdg26.04+1_amd64.deb PGDG · 1.6 · 13.0KiB
u26.aarch64	PGDG 1.6 u26.aarch64.pg18 : postgresql-18-asn1oid postgresql-18-asn1oid_1.6-3.pgdg26.04+1_arm64.deb PGDG · 1.6 · 13.1KiB	PGDG 1.6 u26.aarch64.pg17 : postgresql-17-asn1oid postgresql-17-asn1oid_1.6-3.pgdg26.04+1_arm64.deb PGDG · 1.6 · 13.1KiB	PGDG 1.6 u26.aarch64.pg16 : postgresql-16-asn1oid postgresql-16-asn1oid_1.6-3.pgdg26.04+1_arm64.deb PGDG · 1.6 · 13.1KiB	PGDG 1.6 u26.aarch64.pg15 : postgresql-15-asn1oid postgresql-15-asn1oid_1.6-3.pgdg26.04+1_arm64.deb PGDG · 1.6 · 13.2KiB	PGDG 1.6 u26.aarch64.pg14 : postgresql-14-asn1oid postgresql-14-asn1oid_1.6-3.pgdg26.04+1_arm64.deb PGDG · 1.6 · 13.1KiB

Build

You can build the RPM packages for asn1oid using pig build:

pig build pkg asn1oid         # build RPM packages

Install

You can install asn1oid directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

Install

pig install asn1oid;          # Install for current active PG version

pig

pig ext install -y asn1oid -v 18  # PG 18
pig ext install -y asn1oid -v 17  # PG 17
pig ext install -y asn1oid -v 16  # PG 16
pig ext install -y asn1oid -v 15  # PG 15
pig ext install -y asn1oid -v 14  # PG 14

dnf

dnf install -y asn1oid_18       # PG 18
dnf install -y asn1oid_17       # PG 17
dnf install -y asn1oid_16       # PG 16
dnf install -y asn1oid_15       # PG 15
dnf install -y asn1oid_14       # PG 14

apt

apt install -y postgresql-18-asn1oid   # PG 18
apt install -y postgresql-17-asn1oid   # PG 17
apt install -y postgresql-16-asn1oid   # PG 16
apt install -y postgresql-15-asn1oid   # PG 15
apt install -y postgresql-14-asn1oid   # PG 14

Create Extension:

CREATE EXTENSION asn1oid;

Usage

asn1oid: ASN.1 OID data type for PostgreSQL

The asn1oid extension provides a data type for storing and comparing ASN.1 Object Identifiers (OIDs).

CREATE EXTENSION asn1oid;

SELECT '1.3.6.1.4.1'::asn1oid;
   asn1oid
─────────────
 1.3.6.1.4.1

Data Type

The asn1oid type stores ASN.1 OID values in dotted-decimal notation (e.g., 1.3.6.1.4.1.311). These are hierarchical identifiers used in SNMP, LDAP, X.509 certificates, and other standards.

Operators

Standard comparison operators are supported for ordering and equality: =, <>, <, >, <=, >=.

Casts

The type supports casting to and from text.

asn1oid

Overview

Version

Build

Install

Usage

Data Type

Operators

Casts

Was this page helpful?