#!/bin/sh sqlite3 /var/db/pkg/repo-FreeBSD.sqlite '.schema deps' sqlite3 -header -column /var/db/pkg/repo-FreeBSD.sqlite "select p.name,p.version,d.name,d.origin,d.version from packages p join deps d on p.id=d.package_id where p.name in ('coin-or-cbc','glpk','lp_solve');"