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