asn1oid

asn1oid : asn1oid extension

Overview

Packages

Source

pig build pkg asn1oid;		# build rpm

Install

Make sure PGDG and PIGSTY repo available:

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

Install this extension with pig:

pig install asn1oid;		# install via package name, for the active PG version

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

Create this extension with:

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.