First, you need
PGLobEditor is a database tool that can batch import/export PostgreSQL TEXT (CLOB) data.
Using PGLobEditor you can batch update TEXT (CLOB) data to PostgreSQL easily and fast.
More about PGLobEditor – the tool to batch import/export PostgreSQL TEXT (CLOB) data