Storage and querying of filesystem paths

From: Laura Smith <n5d9xq3ti233xiyif2vp(at)protonmail(dot)ch>
To: postgre <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Storage and querying of filesystem paths
Date: 2020-11-30 12:05:22
Message-ID: 8tVrsHsAWSD22jnyKoaokZfRmhHCjmL1gIa_8Ezxu7rCvyYWOj2g2LJF86lesm3a38dwdzbejpE5VtnO2TV4RdJaqa0uk55viQLERCEtG-Y=@protonmail.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2020-11-30 12:36:34 Re: Storage and querying of filesystem paths
Previous Message Karsten Hilbert 2020-11-30 10:56:23 Re: Set COLLATE on a session level