databasepostgresqltypesclob

PostgreSQL Clob datatype

PostgreSQL supports both clob and text data types for storing large texts. I've used clob data type as we are migrating the DB from Oracle. I understand that the clob data type in PostgreSQL can only store up to 1GB of text rather than the 4GB in oracle.

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 text datatype over clob?

Any help will be much appreciated and Thanks in Advance.

Solution

  • The clob data type is unsupported in Postgres. However, it can be easily defined as a synonym to the text type:

    create domain clob as text;