Skip to main content

ALTER CONNECTION

The ALTER CONNECTION command modifies the definition of a connection. To use this command, you must own the connection.

Syntax

ALTER CONNECTION connection_name
alter_option;

alter_option 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;

Help us make this doc better!