Export data from PostgreSQL table to JSON Lines (JSONL / NDJSON / LDJSON)

Want to export data from PostgreSQL table to JSON lines (JSONL / NDJSON / LDJSON)?

Using Withdata DBToFile, a JSON lines exporter for PostgreSQL, you can export PostgreSQL data to JSON lines (JSONL / NDJSON / LDJSON) easily 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 DBToFile

Export data from PostgreSQL table to JSON lines (JSONL / NDJSON / LDJSON)

Login to PostgreSQL -> Choose PostgreSQL table -> Set JSON lines file options -> Export PostgreSQL to JSON lines (JSONL / NDJSON / LDJSON)

Choose PostgreSQL and logon.

“Export From Table” for “PostgreSQL to JSON lines (JSONL / NDJSON / LDJSON)”.

Select JSON file type.

1. Choose PostgreSQL table.

2. Set JSON lines (JSONL / NDJSON / LDJSON) file options.

3. Summary.

4. Export PostgreSQL data to JSON lines (JSONL / NDJSON / LDJSON) table.

After exporting, you can view output JSON lines (JSONL / NDJSON / LDJSON) file.

Export PostgreSQL to JSON lines (JSONL / NDJSON / LDJSON) in command line

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

• Export PostgreSQL to JSON lines (JSONL / NDJSON / LDJSON) in Windows command line.
• Export PostgreSQL to JSON lines (JSONL / NDJSON / LDJSON) in Linux command line.
• Export PostgreSQL to JSON lines (JSONL / NDJSON / LDJSON) in macOS command line.

Set scheduled tasks for exporting PostgreSQL to JSON lines (JSONL / NDJSON / LDJSON)

You can schedule and automate this “PostgreSQL to JSON lines” conversion task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.

---

More about DBToFile – PostgreSQL to JSON lines (JSONL / NDJSON / LDJSON) converter