Search code examples
vertica

How can I run a series of queries/commands at once in Vertica?

Currently I am using Vertica on Ubuntu from the terminal as dbadmin. I am using admintools to connect a database and then executing queries like Create Table, Select, Insert in the terminal.

Is there any way I can write the commands in any external text file and execute all the query at once? Like for Oracle, We can create a SQL file in Notepad++ and then run all the queries in the database.

Solution

  • Not only can you use scripts, but it's a good practice for any operation that you might need to repeat.

    From the vsql prompt, use the \i command to run a script:

    vsql> \i create_tables.sql

    From outside the vsql prompt, you can invoke vsql with -f filename.

    File paths, if not absolute, are relative to the current working directory.