title: update content of column from another schema.table.column postgresql
body: <p>I have 2 schemas in the same database (postgresql).</p>
  <p><code>schema1</code></p>
  <p><code>schema2</code></p>
  <p>Each schema has table <code>users</code> and <code>mail column</code>.</p>
  <p><strong>how can i copy the content from mail column in schema1.users to mail column to schema2.users for all rows</strong></p>
  <p>i tried:</p>
  <pre><code>update schema1.users
  set mail=(select mail from schema2.users);
  </code></pre>
  <p>but didn't work.</p>