Can someone see what i am doing wrong in the following:
Code: Select all
[dbadmin@vertica-db0]$ vsql -v test=dual -c "select * from :test"
ERROR 4856: Syntax error at or near ":" at character 15
LINE 1: select * from :test
^
Moderator: NorbertKrupa
Code: Select all
[dbadmin@vertica-db0]$ vsql -v test=dual -c "select * from :test"
ERROR 4856: Syntax error at or near ":" at character 15
LINE 1: select * from :test
^
Code: Select all
[dbadmin@flygirl ~]$ vsql -v test=dual
Welcome to vsql, the Vertica Analytic Database interactive terminal.
Type: \h or \? for help with vsql commands
\g or terminate with semicolon to execute query
\q to quit
dbadmin=> select * from :test;
dummy
-------
X
(1 row)
Code: Select all
$ echo "\\set test dual\\\\select * from :test" | /opt/vertica/bin/vsql
dummy
-------
X
(1 row)