‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ On Monday, November 30, 2020 12:36 PM, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote: > 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 Thanks Laurenz. Will take a look at ltree
