CA_BUNDLES

Stores certificate authority (CA) bundles created by CREATE CA BUNDLE.

Stores certificate authority (CA) bundles created by CREATE CA BUNDLE.

Column Name Data Type Description
OID INTEGER The object identifier.
NAME VARCHAR The name of the CA bundle.
OWNER INTEGER The OID of the owner of the CA bundle.
CERTIFICATES INTEGER The OIDs of the CA certificates inside the CA bundle.

Privileges

  • See CA bundle OID, name, and owner: Superuser or owner of the CA bundle.

  • See CA bundle contents: Owner of the bundle

Joining with CERTIFICATES

CA_BUNDLES only stores OIDs. Since operations on CA bundles require certificate and owner names, you can use the following query to map bundles to certificate and owner names:

=> SELECT user_name AS owner_name,
       owner     AS owner_oid,
       b.name    AS bundle_name,
       c.name    AS cert_name
FROM   (SELECT name,
               STRING_TO_ARRAY(certificates) :: array[INT] AS certs
        FROM   ca_bundles) b
       LEFT JOIN certificates c
              ON CONTAINS(b.certs, c.oid)
       LEFT JOIN users
              ON user_id = owner
ORDER  BY 1;

 owner_name |     owner_oid     | bundle_name  | cert_name
------------+-------------------+--------------+-----------
 dbadmin    | 45035996273704962 | ca_bundle    | root_ca
 dbadmin    | 45035996273704962 | ca_bundle    | ca_cert
(2 rows)

See also