Using ltree extension in Postgres

Queries and Resources
1

Hi there,

I am looking to use the ltree extension to easily store a hierarchy in the DB. Can I activate the extension somehow on Retool Cloud?

If not, is it possible to use it if I connect to another Postgres DB and just use Retool to manage the data?

Thanks,
Sina

2

The latter is probably more easily done...Retool wouldn't manage the data but merely present it or manipulate it on the front end....if I am understanding your questions correctly.

3

So currently its not possible to add the ltree extension to the Retool Cloud Postgres?

4

As far as I know but perhaps better answered by someone at Retool

5

Hey @Sina! Are you referring to the Retool DB postgres db? If so, you should be able to add the extension by running a query against the database:

create extension ltree;

6

Works like a charm. That was easy.

(meanwhile connected to another Postgres DB which also worked...)

1 Like