title: PostgreSQL Clob datatype
body: <p>PostgreSQL supports both <code>clob</code> and <code>text</code> data types for storing large texts. I've used <code>clob</code> data type as we are migrating the DB from Oracle. I understand that the <code>clob</code> data type in PostgreSQL can only store up to 1GB of text rather than the 4GB in oracle.</p>
  
  <p>Since my text size is well below 1GB, I am fine with using either of these types. So can I use PostgreSQL clob datatype or is there any advantage for <code>text</code> datatype over <code>clob</code>?</p>
  
  <p>Any help will be much appreciated and Thanks in Advance.</p>