How do I commit an insert that is run from the vsql command line?
Code: Select all
[dbadmin@vertica01 ~]$ vsql -c "select * from jack;"
one
-----
(0 rows)
[dbadmin@vertica01 ~]$ vsql -c "insert into jack values (1);"
OUTPUT
--------
1
(1 row)
[dbadmin@vertica01 ~]$ vsql -c "select * from jack;"
one
-----
(0 rows)