Provides information about the master encryption key being used when using the key management system as a keystore.
Column | Type | Description |
---|---|---|
kms_name | text | Key management system name |
key_id | text | Key ID in key management system |
local_key_id | integer | Sequence of keys used internally by FUJITSU Enterprise Postgres |
status | enum | in-use: Current master encryption key in use used: 過Master encryption key used in the past scheduled: A new encryption key that was requested to update the master encryption key and is to be used. |
Execution example
postgres=# select * from pgx_tde_master_key; kms_name | key_id | local_key_id | status -----------+--------------------------------------+---------------+--------- mykmipsvr | a0eebc99-9c0b-0000-0000-000000000000 | 1 | in-use (1 row)
Note
Do not use queries with "*" in the selection list, as the order of the columns may change or columns may be added.