title: How large can an id get in postgresql
body: <p>I am using postgresql, and was wondering how large</p>
  
  <pre><code>id INTEGER PRIMARY KEY
  </code></pre>
  
  <p>can get compared to </p>
  
  <pre><code>id SERIAL PRIMARY KEY
  </code></pre>
  
  <p>In java an <code>int</code> is 4 bytes (32 bits) so it can get up to 2,147,483,647. Is this the case in postgresql?  If so does that mean I cannot go past 2,147,483,647 rows?</p>