psql -v dateav="2012-01-28" mcdb -p 5555 -U admin -q -t -A -c 'select count (client_name) from v_activities where scheduled_start_date like :'dateav';'
ERROR: syntax error at or near ":"
LINE 1: ...) from v_activities where scheduled_start_date like :dateav;
echo "select count (client_name) from v_activities
where scheduled_start_date like :'dateav'" |
psql -v dateav="2012-01-28" mcdb -p 5555 -U admin -q -t -A
echo 'command' | psql
psql mcdb -p 5555 -U admin -q -t -A
-c "select count (client_name) from v_activities
where scheduled_start_date like '2012-01-28'"
-c 'select ... like $x$2012-01-28$x$'