From nobody Sat Sep 3 16:32:35 2022 X-Original-To: questions@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4MKgMD2wprz4br84 for ; Sat, 3 Sep 2022 16:33:28 +0000 (UTC) (envelope-from kob6558@gmail.com) Received: from mail-il1-x133.google.com (mail-il1-x133.google.com [IPv6:2607:f8b0:4864:20::133]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1D4" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4MKgMC5n3kz3jFx; Sat, 3 Sep 2022 16:33:27 +0000 (UTC) (envelope-from kob6558@gmail.com) Received: by mail-il1-x133.google.com with SMTP id k2so2707349ilu.9; Sat, 03 Sep 2022 09:33:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date; bh=eSRlEhjGbgmItL67zNIxLDhuSYeg1Cuvs1vUpP/PoXI=; b=LBemb/+G4E7WS9JYki2cOXKt2woU/T9s8hGQviIP6ZTEnObwum6T7gl5fLj3KHxXxJ k29Bp50OKCFTtXnMGTr9kbQ9rjUTkVDamn2GzFNgXFOjKUwpU0GaWSgJhIrhx2QIckmz NNLJNbfTnrUbmW8fjvzd1yPD6EHXdrN4l7H1zUx310c5s7+JX+Mvq0iMcrB8QPZ2sdUc hWHP4PzL6Fg77bTT38yafEOimPPLhFc+vRmxIKzEqb4U6+DAb95LtAJf9WcH3TRaciw0 j/d/PGhE7X4NIjGKw5csu7QsAelARvP7XhD1KNAtlnGLHuxpKFZCcpMMlDezShbvLEXf 1L1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date; bh=eSRlEhjGbgmItL67zNIxLDhuSYeg1Cuvs1vUpP/PoXI=; b=dVnXJFIVvKuOa8MTKKmWAec9PBVJg29Pv74usR16ah+eOpRbfu99318k8pOwILsG/1 Jub/ieHdV3eQoRnAh6kLLWyV2WE3q/q4PVF+1rm5eBybguiau/rt0IPZd8mozzOJFcKT 3W/v8BcWc/uJoV0Oowe0fKCShHTv+AJTiHHnq1uXxSjxiOZfrY0dsJCUv1h1VJRC8tda jWslF2oSAr94mlgxhKBYPhJaIDWpgYe00xBcemPezIqByIh543LN44VX/HJKMzkiDfQS h/npbAF35V59vMyJ55VatdnmcubyEbNmA4AFmdTjN8ZP2P0jk9+mp3xkxrgOj2LPJy/r ngrg== X-Gm-Message-State: ACgBeo0jMLPmScEZdfFn11xTGdYkmqDCK1gQkOyr/7xHN3DHLeaMAIya BXpKjSRDPfMTviEE7mpLDyHHhYqb6AJCKWoPzMC+WqZgZPg= X-Google-Smtp-Source: AA6agR5QA4fj6+Zog7ujQPkrkJoVeDomkRYjUPbY8vHZoia3ffzDbfQmwbpkmk0jx70EjXYMPQtfL16Ty0qHom9Ghr8= X-Received: by 2002:a92:c561:0:b0:2ed:a26a:8c65 with SMTP id b1-20020a92c561000000b002eda26a8c65mr6172017ilj.23.1662222806690; Sat, 03 Sep 2022 09:33:26 -0700 (PDT) List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-questions@freebsd.org X-BeenThere: freebsd-questions@freebsd.org MIME-Version: 1.0 References: <9e1c8c23-3c6b-a395-b002-8af3267e73f9@freebsd.org> In-Reply-To: <9e1c8c23-3c6b-a395-b002-8af3267e73f9@freebsd.org> From: Kevin Oberman Date: Sat, 3 Sep 2022 09:32:35 -0700 Message-ID: Subject: Re: pkgdb question To: Graham Perrin Cc: questions@freebsd.org Content-Type: multipart/alternative; boundary="000000000000ee301e05e7c8672b" X-Rspamd-Queue-Id: 4MKgMC5n3kz3jFx X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20210112 header.b="LBemb/+G"; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of kob6558@gmail.com designates 2607:f8b0:4864:20::133 as permitted sender) smtp.mailfrom=kob6558@gmail.com X-Spamd-Result: default: False [-3.69 / 15.00]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_SHORT(-1.00)[-0.999]; NEURAL_HAM_MEDIUM(-0.99)[-0.991]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; FORGED_SENDER(0.30)[rkoberman@gmail.com,kob6558@gmail.com]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36:c]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20210112]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::133:from]; MLMMJ_DEST(0.00)[questions@freebsd.org]; ARC_NA(0.00)[]; FREEMAIL_ENVFROM(0.00)[gmail.com]; MIME_TRACE(0.00)[0:+,1:+,2:~]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; RCPT_COUNT_TWO(0.00)[2]; RCVD_TLS_LAST(0.00)[]; MID_RHS_MATCH_FROMTLD(0.00)[]; TO_DN_SOME(0.00)[]; FROM_HAS_DN(0.00)[]; DKIM_TRACE(0.00)[gmail.com:+]; FREEMAIL_FROM(0.00)[gmail.com]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; TO_MATCH_ENVRCPT_ALL(0.00)[]; FROM_NEQ_ENVFROM(0.00)[rkoberman@gmail.com,kob6558@gmail.com]; RCVD_COUNT_TWO(0.00)[2] X-ThisMailContainsUnwantedMimeParts: N --000000000000ee301e05e7c8672b Content-Type: text/plain; charset="UTF-8" On Sat, Sep 3, 2022 at 9:19 AM Graham Perrin 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
On Sat, Sep 3, 2022 at 9:19 AM = Graham Perrin <grahamperrin@= freebsd.org> wrote:
=20 =20 =20
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 Engin= eer
E-mail: rko= berman@gmail.com
PGP Fingerprint: D03FB98AFA78E3B78C1694B= 318AB39EF1B055683
--000000000000ee301e05e7c8672b--