pkg_packages
============

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.

.. code-block:: sql

   SELECT * FROM pkg_packages;