Syntax

ALTER CONNECTION connection_name
    alter_option;

alteroption depends on the operation you want to perform on the connection. For all supported clauses, see the sections below.

Clause

SET SCHEMA

ALTER CONNECTION connection_name
    SET SCHEMA schema_name;
Parameter or clauseDescription
SET SCHEMAThis clause changes the schema of the connection. To change a connection’s schema, you must also have CREATE privilege on the new schema.
schema_nameSpecify the schema to which you want to change.
-- Change the schema of the connection named "test_conn" to a schema named "test_schema"
ALTER CONNECTION test_conn SET SCHEMA test_schema;