Changes the current database connection to another server.
set connection_name : identifier , string, or hostvar
connection_name – the login name you are using to make the connection.
identifier – the identifier you are using for the connection information.
string – the string you are using for the connection information.
hostvar – variable information for the host name and port.
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.
Any user can run this command.