I need to echo errors to an out file when running a vsql script. I cannot get errors to echo out.
Example:
Here is my script:
Code: Select all
[dbadmin@Vertica1 ~]$ cat test.sql
\o /home/dbadmin/test.log
create user test;
\o
Code: Select all
[dbadmin@Vertica1 ~]$ vsql -f test.sql
[dbadmin@Vertica1 ~]$ cat /home/dbadmin/test.log
CREATE USER
Code: Select all
[dbadmin@Vertica1 ~]$ vsql -f test.sql
vsql:test.sql:2: ROLLBACK 5403: User/role "test" already exists
[dbadmin@Vertica1 ~]$ cat /home/dbadmin/test.log
Anyone know how to do this?