Connect to Database

This tool connects to a running database with vsql. You can use the Administration Tools to connect to a database from any node within the database while logged into any user account with access privileges. You cannot use the Administration Tools to connect from a host that is not a database node. To connect from other hosts, run vsql as described in Connecting From the Command Line in the SQL Programmer's Guide.

1. On the Main Menu, select Connect to Database.

   

2. Supply the database password if asked:

   Password:

   The Administration Tools maintain a session context with regard to password authentication. In other words, you are required to enter a password for a database once per Administration Tools session. If you enter it correctly, you will not be asked to enter it again until the next time you run the Administration Tools. If you enter an incorrect password you must exit the Administration Tools and run it again.

3. The Administration Tools connect to the database and transfer control to vsql.

   vsql is the Vertica implementation of psql, a character-based, interactive, front-end that is part of PostgreSQL and used by other database management systems. It allows you to type in SQL statements and see the results. It also provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks.

   Welcome to the vsql, Vertica_Database v2.1.GA interactive terminal.

   Type: \h for help with SQL commands

   \? for help with vsql commands

   \g or terminate with semicolon to execute query

   \q to quit

   Stock_Schema=>

   Refer to Using vsql in the SQL Programmer's Guide for more information.