Hi, The vsql \set meta-command is used to set variables ( ON_ERROR_STOP is a variable): See: http://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/ConnectingToHPVertica/vsql/Variables.htm While the SET command sets "run-time parameters" for the current session. SEARCH_PATH is one of these param...

Thanks, I'll give it a try... any explanation as to why the set in the search_path doesn't use "\"?

Thanks for the response.. I think I found the problem. I was using \set ON_ERROR_STOP in FILELIST.sql and then I had some characters in the insert file that weren't visible. Once I cleaned up the insert.sql file ( I used the dos2unix command ), things worked. Now next question is, how can I set a pa...

Disclaimer: I'm new to Vertica. I have a shell script that runs a SQL script with vsql i.e. runVSQL.sh: <code> #/bin/sh vsql -f FILELIST.sql </code> FILELIST contains a list of other SQL scripts to run. i.e. FILELIST.sql: <code> \i insert.sql </code> This works fine when the SQL scripts it's running...