Want to batch import JSON documents into PostgreSQL TEXT (CLOB) or BYTEA (BLOB) column?
Using DBBlobEditor, you can import bulk json files into PostgreSQL TEXT (CLOB) or BYTEA (BLOB) easily and fast, just a few mouse clicks.
Here you can download and install DBBlobEditor.
Batch import JSON documents to PostgreSQL TEXT (CLOB) column
Click “Start New Task – Import LOB From Files” at task dialog.
then show the wizard.
1. Config.
2. Import.
then you can see importing results
You can schedule and automate this converting task by:
1) Save session and create .bat file.
More about DBBlobEditor – the tool to batch import JSON documents to PostgreSQL TEXT (CLOB) column