set connection

Changes the current database connection to another server.

Syntax

set connection {identifier | string | hostvar}

Parameters

Usage

The set connection statement changes the active database connection to another server. The current connection state is saved, and resumes again when it again becomes the active connection. If you omit connection_name and there is a connection that was not named, that connection becomes the active connection.

Permissions

Any user can execute this command.

Related reference
connect
disconnect