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

oid

oid

Row identifier (hidden column)

rel_id

oid

Table OID

column_name

name

Name of an encrypted column.

column_key_id

oid

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 value, see oid in the PG_TYPE system catalog.

data_type_original_mod

integer

Original data type modifier of the encrypted column. For details about the value, see atttypmod in the PG_ATTRIBUTE system catalog. The value of data_type_original_mod is generally –1 when data types are not specific.

create_date

timestamp without time zone

Time when an encrypted column is created