pkgng packages that are currently installed on the host system.

Platform support

Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error: no such table: pkg_packages

  • Free BSD

Table schema

Name Type Description
name TEXT Package name
version TEXT Package version
flatsize BIGINT Package size in bytes
arch TEXT Architecture(s) supported

Query examples

Select all the results for the given table.

SELECT * FROM pkg_packages;