System Catalogs / System catalogs
pg_range
Read the PG 18 manualThe catalog pg_range stores information about range types.
Reading PG 18current·documented in 16 of 24 versions, 9.2 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 7
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 7
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
rngtypid | oidNOT NULL | OID of the range type pg_type.oid |
rngsubtype | oidNOT NULL | OID of the element type (subtype) of this range type pg_type.oid |
rngmultitypid | oidNOT NULL | OID of the multirange type for this range type pg_type.oid |
rngcollation | oidNOT NULL | OID of the collation used for range comparisons, or zero if none pg_collation.oid |
rngsubopc | oidNOT NULL | OID of the subtype's operator class used for range comparisons pg_opclass.oid |
rngcanonical | regprocNOT NULL | OID of the function to convert a range value into canonical form, or zero if none pg_proc.oid |
rngsubdiff | regprocNOT NULL | OID of the function to return the difference between two element values as double precision, or zero if none pg_proc.oid |
Column history across versions
Definition snapshot: english-manuals:0af05c551400513b4770b88698a… · English manual source