GS_COLUMN_KEYS
GS_COLUMN_KEYSrecords 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.