Updated on 2024-06-03 GMT+08:00

GS_SPM_SQL_PARAM

GS_SPM_SQL_PARAM is used to view the SQL parameter information of the current user. Users with permissions higher than common users can access this view.

Table 1 GS_SPM_SQL_PARAM columns

Name

Type

Description

sql_namespace

oid

OID of a schema.

sql_hash

bigint

Unique ID of an SQL statement in the current schema.

sql_text

text

SQL text string.

position

integer

Position index of a parameter in the SQL statement, starting from 0.

datatype

integer

OID of the parameter type.

datatype_string

text

Character string of a parameter type.

value_string

text

Character string of a parameter value.

is_null

Boolean

Specifies whether a parameter value is NULL.

hash_value

bigint

Hash value of a parameter value.

creation_time

timestamp with time zone

Time when a record is created.