title: PostgreSQL: Changing multiple PK/id, while keeping its relation in other table
body: <p>I have 2 table, <code>Pricelist</code> &amp; <code>Items</code>, each items record have a ForeignKey to <code>Pricelist</code> Primary Key.</p>
  <p>See: <a href="https://dbfiddle.uk/?rdbms=postgres_12&amp;fiddle=e3a74844058956b1f3d5ef0c6830c8ce" rel="nofollow noreferrer">https://dbfiddle.uk/?rdbms=postgres_12&amp;fiddle=e3a74844058956b1f3d5ef0c6830c8ce</a></p>
  <p><strong>Question:</strong>
  is there a way to bulk change the <code>pricelist_id(pk)</code>  for example <code>pricelist_id</code> (<code>1</code> &amp; <code>2</code>) to (<code>10</code> &amp; <code>11</code>) (<strong>autoincrement</strong>), while keeping its relation in <code>Item table</code> on other words, the value <code>pricelist_id</code> in <code>Item</code> table adjusted to the new <code>Pricelist</code> id.</p>
  <p>Pricelist table:</p>
  <p><a href="https://i.stack.imgur.com/nAgQ3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nAgQ3.png" alt="enter image description here" /></a></p>
  <p>Item table:</p>
  <p><a href="https://i.stack.imgur.com/F6fss.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F6fss.png" alt="enter image description here" /></a></p>