GS_SPM_PARAM

GS_SPM_PARAM is a system catalog used to store SQL parameters. Each SQL statement stores only one group of parameters. Users with the sysadmin permission can read the system catalog, but only initial users can write the system catalog.

**Table 1** GS_SPM_PARAM columns
Name	Type	Description
sql_namespace	oid	Schema OID
sql_hash	bigint	Unique ID of the SQL statement in the SPM.
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	Determines whether a parameter value is NULL.
hash_value	bigint	Hash value of a parameter value.
user	oid	User who creates the record.
creation_time	timestamp with time zone	Time when a record is created.