ltree
data type for hierarchical tree-like structures
Overview
| 3960 | ltree | ltree | 1.3 | TYPE | PostgreSQL | C |
Attributes
| Yes | No | Yes | No | Yes | Unknown | Yes | - |
Packages
| EL | CONTRIB | postgresql$v-contrib | 1.3 | - | 17 16 15 14 13 |
| Debian | CONTRIB | postgresql-$v | 1.3 | - | 17 16 15 14 13 |
Dependent Extensions
The following extensions depend on this extension: ltree_plpython3u
Availability
| PG17 | PG16 | PG15 | PG14 | PG13 | |
|---|---|---|---|---|---|
el8.x86_64 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
el8.aarch64 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
el9.x86_64 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
el9.aarch64 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
d12.x86_64 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
d12.aarch64 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
u22.x86_64 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
u22.aarch64 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
u24.x86_64 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
u24.aarch64 | 1.3 | 1.3 | 1.3 | 1.3 | 1.3 |
CONTRIB
PGDG
PIGSTY
Download
This extension is built-in with PostgreSQL and does not need separate download.
Install
Extension ltree is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Create this extension on PostgreSQL database with:
CREATE EXTENSION ltree;