querying the registry for installed files

Vincent Habchi vince at macports.org
Fri Oct 28 12:34:32 PDT 2016

> if ‘exp’ is the expression you’re looking for (e.g. ‘%qt4%’ for all files containing …qt4…)
> sqlite> WITH i AS (SELECT id FROM files WHERE path LIKE exp GROUP BY id) SELECT name FROM ports, i WHERE ports.id = i.id;
> Assuming you want the name of the ports which provides the files you’re looking for

Oh, if you want the files, a simple

SELECT path FROM ports WHERE path LIKE exp; 

is enough!


More information about the macports-dev mailing list