Using the NuoDB SQL Init File

At startup, nuosql will look for a file called $HOME/.nuosql.init. This file is expected to contain SQL commands to be executed by nuosql. The location of the .nuosql.init file can be overridden with the --init command line option. The commands in the .nuosql.init file are executed every time nuosql starts up. This .nuosql.init can include any valid SQL statement and is particularly useful for the SET command and specifying settings such as “SET PAGER less” and “SET OUTPUT VERTICAL”. (See SET.) After connecting to the database and executing all the commands in the .nuosql.init file, nuosql displays the usual command line prompt and waits for additional commands to be entered interactively.