Batch insert PostgreSQL table TEXT data from files

by

Posted on by

Want to batch insert PostgreSQL TEXT (CLOB) data from files ?

Try Withdata DBBlobEditor, a PostgreSQL TEXT (CLOB) editor, Bulk insert PostgreSQL TEXT (CLOB) data from files, 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.
  • Support Windows, Linux, macOS.

Download Withdata DBBlobEditor Download DBBlobEditor

Batch insert PostgreSQL TEXT (CLOB) data from files

Run DBBlobEditor, login to PostgreSQL.

Bulk insert PostgreSQL TEXT (CLOB) data from files - login to PostgreSQL

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

Batch insert PostgreSQL TEXT (CLOB) data from files - Task Window

then choose PostgreSQL table to insert TEXT (CLOB).

Batch insert PostgreSQL TEXT (CLOB) data from files

Batch insert PostgreSQL TEXT (CLOB) data from files in command line

Save “Bulk inserting PostgreSQL TEXT (CLOB) to files” session, then you can:

Set scheduled tasks for bulk inserting PostgreSQL TEXT (CLOB) data from files

You can schedule and automate this converting task by:

  1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “Bulk inserting PostgreSQL TEXT (CLOB) data from files” conversion.
  2. Set scheduled task for “Bulk inserting PostgreSQL TEXT (CLOB) data from files” conversion.

More about Withdata DBBlobEditor – PostgreSQL TEXT (CLOB) importer

See Video: Batch import data from files in a folder to postgresql TEXT (CLOB) in a few clicks