GS_COLUMN_KEYS
**GS_COLUMN_KEYS **records information about the CEK in the encrypted equality feature. Each record corresponds to a CEK.
Table 1 GS_COLUMN_KEYS columns
Name | Type | Description |
|---|
oid | oid | Row identifier (hidden column) |
column_key_name | name | CEK name |
column_key_distributed_id | oid | ID obtained based on the hash value of the fully qualified domain name (FQDN) of the CEK |
global_key_id | oid | Foreign key, which is the CMK OID |
key_namespace | oid | Namespace OID that contains the CEK |
key_owner | oid | CEK owner |
create_date | timestamp | Time when the CEK is created |
key_acl | aclitem[] | Access permissions that the CEK should have on creation |
NOTE:
In the Lite scenario, openGauss provides this system catalog, but the encrypted equality feature is unavailable.
openGauss 2025-07-15 22:42:49