Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ System Catalogs and System Views/ System Catalogs/ Encrypted Equality Query/ GS_COLUMN_KEYS
Updated on 2025-08-19 GMT+08:00
View PDF

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
Parent topic: Encrypted Equality Query