title: Update table - relation does not exist
body: <p>I am trying this query, however is not working:
  The idea is copy data from one table to another.</p>
  
  <pre><code>UPDATE  A
  SET     A.name_en = B.name
  FROM    country_name as A
          INNER JOIN country as B
              ON A.id = B.id
  </code></pre>
  
  <p>I am getting this error:</p>
  
  <pre><code>Error in query: ERROR: relation "a" does not exist
  LINE 1: UPDATE A
  </code></pre>
  
  <p>Why?</p>