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.
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.