title: update two tables at the same time postgresql
body: <p>I have a problem in POSTGRESQL.</p>
  
  <p>I want to update two tables at the same time. Both update can be applied since they have the same condition.</p>
  
  <p>Here's the individual update:</p>
  
  <pre><code>UPDATE standards.standards
  SET description = 'The student will demonstrate positive self esteem.'
  WHERE description LIKE 'The student will demonstrate positive his/her self esteem.' 
  AND custom_code LIKE 'qwertyuiop';
  
  UPDATE bank SET description = 'The student will demonstrate positive self esteem.'
  WHERE description LIKE 'The student will demonstrate positive his/her self esteem.'
  AND designation LIKE 'asdfghjkl';
  </code></pre>
  
  <p>I want to update both in just one sql statement. Here's something I did but got an error since POSTGRESQL does not allow update of two tables at the same time.</p>
  
  <pre><code>UPDATE standards.standards ss, bank bb
  SET description = 'The student will demonstrate positive self esteem.'
  WHERE description LIKE 'The student will demonstrate positive his/her self esteem.'
  AND (ss.custom_code LIKE 'qwertyuiop' OR bb.designation LIKE 'asdfghjkl');
  </code></pre>
  
  <p>Can you help me on this? I want just one sql statement. Thanks!</p>