Updated on 2023-10-23 GMT+08:00

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 without time zone

Time when the CEK is created

key_acl

aclitem[]

Access permissions that the CEK should have on creation