According to https://dzone.com/articles/installing-the-postgres-ltree-extension, ltree is installed and enabled on my computer. But when I try to make a table with a column of type ltree
in Postbird, it says 'type "ltree" does not exist'. This makes no sense. Please help.
Asked
Active
Viewed 428 times
0

eric_heim
- 31
- 1
- 6
-
Is the schema it is installed into in your search_path? – jjanes May 14 '21 at 13:15
1 Answers
0
Only execute this command in psql or some postgresql's sql client:
CREATE EXTENSION ltree;

bencarsal
- 21
- 4