title: PostgreSQL Primary Key sequence lost after migration using AWS DMS
body: <p>I recently migrated a self hosted Postgres database to AWS RDS using the AWS Migration Service.<br>
  Postgres Version: 10.6</p>
  
  <p>I have noticed that all of my primary keys are no longer set to "sequence", and when I attempt to manually add a sequence it starts at 1 instead of continuing the count that is already set. </p>
  
  <p>I use Rails with the database, so my sql skills are pretty low. I can generally find my way around inserts and updates, but this is not a realm I have much experience in.</p>
  
  <p>My question has 2 parts:</p>
  
  <ol>
  <li>How do I fix a single table? I want to understand and test what I am doing before moving on.</li>
  <li>Is there a way I can apply this fix to every table I have without needing to manually modify each table?</li>
  </ol>