title: PostgreSQL query not working in Yii2
body: <p>I want to execute query in my yii2 application. I'm using PostgreSQl. There is a table called <strong>list</strong> inside the <strong>user</strong> schema. If I try to build any query it returns <strong>1</strong>. My code is here:</p>
  
  <pre><code>$numUsers = Yii::$app-&gt;db-&gt;createCommand('
      SELECT COUNT(*) FROM "user"."list"
  ')-&gt;execute();
  </code></pre>
  
  <p>Please show me my mistake in the query above.</p>