Commit after insert in -c option of vsql
Posted: Fri Dec 13, 2013 5:55 pm
Hi,
How do I commit an insert that is run from the vsql command line?
See the data was not committed? Is there a command line switch for auto commit?
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)