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

GS_SPM_SQL_PARAM

GS_SPM_SQL_PARAM is a system view of the SPM feature. Currently, this feature is not supported in the distributed system. This view 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.