title: PostgreSQL change field sequence
body: <p>There was a problem copying some tables from one schema to another and now I have a few tables with serial fields pointing another schema's sequences. I want to change that dependency.</p>
  
  <p>I need to copy those sequences to the table schema and change the field to point the copies in the current table schema.</p>
  
  <p>Table 1 definition:</p>
  
  <pre><code>CREATE TABLE schema1.table1
  (
      gid integer NOT NULL DEFAULT nextval('schema2.table1_seq'::regclass),
      ...
  )
  </code></pre>
  
  <p>I want it to point schema1.table1_seq . Is it posible?</p>