云数据库 GaussDB-ALTER SESSION:语法格式

时间：2023-11-01 16:22:12

云数据库 GaussDB

语法格式

设置会话的事务参数。

    
         ALTER SESSION SET [ SESSION CHARACTERISTICS AS ] TRANSACTION    { ISOLATION LEVEL { READ COMMITTED | READ UNCOMMITTED } | { READ ONLY  | READ WRITE } } [, ...] ;

设置会话的其他运行时参数。

    
         ALTER SESSION SET     {{config_parameter { { TO  | =  }  { value | DEFAULT }      | FROM CURRENT }} | CURRENT_SCHEMA [ TO | = ] { schema | DEFAULT }      | TIME ZONE time_zone      | SCHEMA schema      | NAMES encoding_name      | ROLE role_name PASSWORD 'password'      | SESSION AUTHORIZATION { role_name PASSWORD 'password' | DEFAULT }      | XML OPTION { DOCUMENT | CONTENT }    } ;