When I execute a SELECT to my TestTable, output is as expected, vsql -dX -c "SELECT * FROM TestTable;" but when I introduce something like: vsql -dX -c "SELECT * FROM TestTable; DROP TABLE IF EXISTS TestTable;" Does not show anything and does not throw an error neither Does anybody know the cause?

I solve it now I upgraded, but anyway I think it would really be great if ALTERing USER did not need a connection restart. It's bad for long and compelx scripts, for instance, where you need to reopen a connection everytime you change ! Any solution for changing it permanently dynamically and easily?

You're right. My fault. 6.0.1...

Sorry it is not working for me. May you help me? VMart=> \du List of users User name | Is Superuser -----------+-------------- dbadmin | t (1 row) VMart=> ALTER USER dbadmin SEARCH_PATH temp; ERROR 4856: Syntax error at or near "SEARCH_PATH" at character 20 LINE 1: ALTER USER dbadmin SEARCH_PATH tem...

Thanks!!

Can I deactivate the option for buffering results?
I mean the pause and ----- more ----- thing from the console

Thank you!

Is there any easy way to emulate MySQL's and others GROUP_CONCAT (Concat as an aggregation function) without needing to create a procedure in Vertica? Thanks!