Thread: Storage and querying of filesystem paths

Storage and querying of filesystem paths

From
Laura Smith
Date:
Hi,
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 ?
Laura



Re: Storage and querying of filesystem paths

From
Laurenz Albe
Date:
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




Re: Storage and querying of filesystem paths

From
Laura Smith
Date:
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
On Monday, November 30, 2020 12:36 PM, Laurenz Albe <laurenz.albe@cybertec.at> 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