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

GS_ENCRYPTED_PROC

GS_ENCRYPTED_PROC provides information such as the parameters of encrypted functions and stored procedure functions, original data type of return values, and encrypted columns.

Table 1 GS_ENCRYPTED_PROC columns

Name

Type

Description

oid

oid

Row identifier (hidden column)

func_id

oid

OID of the function, corresponding to the OID row identifier in the pg_proc system catalog.

prorettype_orig

integer

Original data type of the return value.

last_change

timestamp without time zone

Last modification time of the encrypted function

proargcachedcol

oidvector

OID of the encrypted column corresponding to the INPUT parameter of the function, corresponding to the OID row identifier in the gs_encrypted_columns system catalog.

proallargtypes_orig

oid[]

Original data type of all function parameters.