Batch import JSON into PostgreSQL TEXT

Want to batch import JSON documents into PostgreSQL TEXT (CLOB) column?

Try Withdata DBBlobEditor, a PostgreSQL TEXT (CLOB) editor for Windows, Mac, and Linux, Bulk import JSON into PostgreSQL, East and Fast.

• Can run in GUI mode, Step by Step, just a few mouse clicks.
• Can run in Command line, for Scheduled Tasks and Streams.

Download DBBlobEditor
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Batch import JSON documents to PostgreSQL TEXT (CLOB) column

Run DBBlobEditor, login to PostgreSQL.

Click “Start New Task – Import LOB From Files” at task dialog.

then show the wizard.

1. Configure import JSON settings.

2. Bulk import JSON files to PostgreSQL TEXT (CLOB).

then you can see importing results

Bulk import JSON to PostgreSQL in command line

Save “Bulk import JSON to PostgreSQL” session, then you can:

• Bulk import JSON to PostgreSQL in Windows command line.
• Bulk import JSON to PostgreSQL in Linux command line.
• Bulk import JSON to PostgreSQL in macOS command line.

Set scheduled tasks for bulk import JSON to PostgreSQL

You can schedule and automate this converting task by:

1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “Bulk import JSON to PostgreSQL” conversion.
2. Set scheduled task for “Bulk import JSON to PostgreSQL” conversion.

FAQ

More about Withdata DBBlobEditor – JSON to PostgreSQL TEXT (CLOB) importer