Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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$'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement