aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_set_session
Parameters
Name
Type
Mode
variable_name
text
IN
value
text
IN
variable_name
citext
IN
value
text
IN
Definition
begin CREATE TEMP TABLE IF NOT EXISTS session_variables ( var_name citext NOT NULL, var_value text, CONSTRAINT pk_session_variables PRIMARY KEY (var_name) ); insert into session_variables values(upper($1), $2) on conflict(var_name) do update set var_value = $2; end