Skip site navigation (1)Skip section navigation (2) 
Date:      Sat, 3 Sep 2022 09:32:35 -0700
From:      Kevin Oberman <rkoberman@gmail.com>
To:        Graham Perrin <grahamperrin@freebsd.org>
Cc:        questions@freebsd.org
Subject:   Re: pkgdb question
Message-ID:  <CAN6yY1teeqfpfgN4zpNJmYftb%2B%2B_4qAvR_t-RyQ=j5BMqyQG8A@mail.gmail.com>
In-Reply-To: <9e1c8c23-3c6b-a395-b002-8af3267e73f9@freebsd.org>
References:  <CAMtcK2p%2BroY87MO_ENKeyAWk90hMX=JGHCmj1eoHscto9w1LPw@mail.gmail.com> <9e1c8c23-3c6b-a395-b002-8af3267e73f9@freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help 
--000000000000ee301e05e7c8672b
Content-Type: text/plain; charset="UTF-8"

On Sat, Sep 3, 2022 at 9:19 AM Graham Perrin <grahamperrin@freebsd.org>
wrote:

> On 02/09/2022 23:57, paul beard wrote:
>
> list of ports, preferably w origins,
>
> pkg prime-origins | sort
>

Or, if you need name and origin, use sqlite3:
sqlite3 local.sqlite "select name, origin from packages"

-- 
Kevin Oberman, Part time kid herder and retired Network Engineer
E-mail: rkoberman@gmail.com
PGP Fingerprint: D03FB98AFA78E3B78C1694B318AB39EF1B055683

--000000000000ee301e05e7c8672b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:tahoma,sans-serif;font-size:small">On Sat, Sep 3, 2022 at 9:19 AM =
Graham Perrin &lt;<a href=3D"mailto:grahamperrin@freebsd.org">grahamperrin@=
freebsd.org</a>&gt; wrote:<br></div></div><div class=3D"gmail_quote"><block=
quote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1=
px solid rgb(204,204,204);padding-left:1ex">
 =20
   =20
 =20
  <div>
    <div>On 02/09/2022 23:57, paul beard wrote:<br>
    </div>
    <blockquote type=3D"cite">
      list of ports, preferably w origins, </blockquote>
    <p><span style=3D"font-family:monospace"><span style=3D"color:rgb(0,0,0=
);background-color:rgb(255,255,255)">pkg
          prime-origins | sort</span><br></span></p></div></blockquote><div=
><br></div><div style=3D"font-family:tahoma,sans-serif;font-size:small" cla=
ss=3D"gmail_default">Or, if you need name and origin, use sqlite3:</div><di=
v style=3D"font-family:tahoma,sans-serif;font-size:small" class=3D"gmail_de=
fault">sqlite3 local.sqlite &quot;select name, origin from packages&quot;</=
div></div><div style=3D"font-family:tahoma,sans-serif;font-size:small" clas=
s=3D"gmail_default"> <br></div>-- <br><div dir=3D"ltr" class=3D"gmail_signa=
ture"><div dir=3D"ltr"><div><div dir=3D"ltr"><div><div dir=3D"ltr"><div><di=
v dir=3D"ltr">Kevin Oberman, Part time kid herder and retired Network Engin=
eer<br>E-mail: <a href=3D"mailto:rkoberman@gmail.com" target=3D"_blank">rko=
berman@gmail.com</a><br></div><div>PGP Fingerprint: D03FB98AFA78E3B78C1694B=
318AB39EF1B055683</div></div></div></div></div></div></div></div></div>

--000000000000ee301e05e7c8672b--

Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAN6yY1teeqfpfgN4zpNJmYftb%2B%2B_4qAvR_t-RyQ=j5BMqyQG8A>