Cockroach: cli: support for \connect to a different DB

[ricardocrdb]

Requesting to add support for \connect database similar to psql format, to be used in addition to how USE database is currently used in CRDB.

[blathers-crl[bot]]

Hello, I am Blathers. I am here to help you get the issue triaged.

It looks like you have not filled out the issue in the format of any of our templates. To best assist you, we advise you to use one of these templates.

I have CC'd a few people who may be able to assist you:

• @tim-o (member of the technical support engineering team)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}

[mneverov]

is this ticket about introducing an alias for SET (like USE) or should the full support of the \connect command be implemented?

\c or \connect [ -reuse-previous=on|off ] [ dbname [ username ] [ host ] [ port ] | conninfo ]

[adzimzf]

Hi, I'll to work on this,

[jordanlewis]

@mneverov, we can start just with an alias for USE. Changing the connection to a different host and port could be interesting, but I think it's used far less frequently than the simple alias.