Provide the command as a single, quoted argument:
watch 'psql --username=nm -d portal -h 192.168.1.27 -c "SELECT count(*) from users;"'