Postgres Pro
Downloads
Home   >   mailing lists

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

From Laura Smith
Subject Storage and querying of filesystem paths
Date
Msg-id 8tVrsHsAWSD22jnyKoaokZfRmhHCjmL1gIa_8Ezxu7rCvyYWOj2g2LJF86lesm3a38dwdzbejpE5VtnO2TV4RdJaqa0uk55viQLERCEtG-Y=@protonmail.ch
Whole thread Raw
Responses Re: Storage and querying of filesystem paths  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: Set COLLATE on a session level
Next
From: Laurenz Albe
Date:
Subject: Re: Storage and querying of filesystem paths