#!/bin/sh
which sqlite3
sqlite3 /var/db/pkg/repo-FreeBSD.sqlite '.schema packages' | head -n60
sqlite3 -header -column /var/db/pkg/repo-FreeBSD.sqlite 'select * from packages where name in ("coin-or-cbc","glpk");' | head -n30