asn1oid

Overview

Version

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
• dnf
• apt

pig install asn1oid;          # Install for current active PG version

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 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 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.