On Mon, 2020-11-30 at 12:05 +0000, Laura Smith wrote:
> How have others approached the problem of storing and querying filesystem paths ?
> I'm talking about *nix/*nux style paths, e.g. /home/foo/bar
> A text column with a GIN index is an obvious possibility, but I'm interested to hear what approach others have taken ?
I have not personally taken that approach, but you could give the
ltree extension a go.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com