Create the Logical Schema

1. Connect to the Database

   

   Connect to the database. See Connect to Database for details.

   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

   =>

2. Execute the Logical Schema Script

   Using the \i meta-command in vsql to execute the SQL logical schema script that you prepared earlier. For example:

   Reads input from the file filename and executes it as though it had been typed on the keyboard.

   Note: To see the lines on the screen as they are read, set the variable ECHO to all.

3. Disconnect From the Database

   Use the \q meta-command in vsql to return to the Administration Tools.

   Quits the vsql program.