In PostgreSQL, there isn’t a direct equivalent of the CLOB (Character Large Object) type like in some other database systems such as DB2 or Oracle. However, PostgreSQL provides data types that can be used to handle large amounts of character data, mainly the TEXT type.
Sometimes you need to extract PostgreSQL TEXT (CLOB) data to files, you can use Withdata DBBlobEditor as PostgreSQL TEXT (CLOB) extractor.
Works GREAT in 2025.
Support Windows, Linux, and macOS.
Can run in GUI mode, Step by Step, just a few mouse clicks.
Can run in CLI (Command Line Interface), for Scheduled Tasks and Streams, for Automation.
After exporting PostgreSQL TEXT (CLOB) data in GUI, and Saving "Extract PostgreSQL TEXT (CLOB)" session, then you can: