title: How to dynamically update sequence in postgreSQL
body: <p>I need to update sequences in more then <code>26 tables</code> on various system </p>
  
  <p>Right now I am doing <code>SELECT setval('auth_group_id_seq', max(id)) FROM auth_group;</code> for every table.</p>
  
  <p>But is their a way where I can iterate over every table available in <code>\dt public.*</code> and then update the sequences.</p>
  
  <p>I thought of doing something like this but got error instead <code>select table_name from tables where tables IN (\dt public.*);</code></p>