I haven't played much with extensions. I should spend some time checking them out. Very true, I should have mentioned that. Backticks are great for that if you need values from bash. Toss in some grep, awk and sed, you can do some scripting work to set variables. datawhisperer=> \set vertica_pid `ps...
Has anyone else had issues w/ time and timezones using SQuirreL? We use it extensively, but have a few people in different timezones and of course SQuirreL localizes the time to them. Normally I don't care, but it's doing this to the TIME data-type, which is unacceptable. It's treating it like TIMET...
Haven't seen much here, but it is possible to run bash commands from the vsql prompt. Why is this handy? Well updating your SVN repo to execute new code w/o having to leave vsql or open another prompt. Example 1: Get your working directory datawhisperer=> \! pwd /home/datawhisperer Example 2: SVN up...