Re: Storage and querying of filesystem paths - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Storage and querying of filesystem paths
Date
Msg-id 291fe29186546258c6ae807a7efb20b3edda8a2c.camel@cybertec.at
Whole thread Raw
In response to Storage and querying of filesystem paths  (Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.ch>)
Responses Re: Storage and querying of filesystem paths  (Laura Smith <n5d9xq3ti233xiyif2vp@protonmail.ch>)
List pgsql-general
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




pgsql-general by date:

Previous
From: Laura Smith
Date:
Subject: Storage and querying of filesystem paths
Next
From: Thibaut Madelaine
Date:
Subject: Re: Migration from SQL Server to PostgeSQL