Connect to a different database

[harryrundles]

Hello,

I see that the \c meta command can be used to connect to another database (DBNAME):

From the help screen:

Code: Select all

   \c[onnect] [DBNAME|- [USER]]
                 connect to new database (currently "dbadmin")

But I thought we can only have one database running at a time in the cluster? Do you think Vertica will allow multiple databases in the future and that is why \c requires a database name? That'd be nice!

[jpcavanaugh]

The vertica process is designed to be able to use all available resources (cpu/mem) so they don't allow more than one to run at a time.