Product Documentationsys.key
This system view returns information about the keys for which the current user has encrypt or decrypt rights or is the owner.
| Column Name | Data Type | Description |
|---|---|---|
| key_id | bigint | The unique ID of the key |
| name | text | The name of the key |
| schema_id | bigint | The unique ID of the schema |
| owner_id | bigint | The unique ID of the user who owns the key |
| creation_time | timestamp with time zone | When the key was created |
For example:
premdb=> select * from sys.key;
key_id | name | schema_id | owner_id | creation_time
--------+----------+-----------+----------+-------------------------------
16480 | yb100key | 2200 | 16007 | 2019-11-07 15:26:30.577896-08
(1 row)