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

GS_ENCRYPTED_COLUMNS

GS_ENCRYPTED_COLUMNS records information about encrypted columns in the encrypted equality feature. Each record corresponds to an encrypted column.

Table 1 GS_ENCRYPTED_COLUMNS columns

Name

Type

Description

rel_id

oid

Table OID

column_name

name

Name of an encrypted column.

column_key_id

oid

A foreign key, which is the CEK OID

encryption_type

tinyint

Encryption type. The value can be 2(DETERMINISTIC) or 1(RANDOMIZED).

data_type_original_oid

oid

ID of the original data type of the encrypted column. For details about the values, see the oid columns in the PG_TYPE system catalog.

data_type_original_mod

integer

Modifiers of the original data type of the encrypted column. For details about the values, see the atttypmod columns in the PG_ATTRIBUTE system catalog.

create_date

timestamp with time zone

Time when an encrypted column is created