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

by

Posted on by

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

Try Withdata DBToFile, Support Windows, Linux, and macOS, Export PostgreSQL data to JSON lines (JSONL / NDJSON / LDJSON), Easy and Fast.

Download Withdata DBToFile Download DBToFile

JSON Lines text format (JSONL), also called Newline-delimited JSON (NDJSON), or Line-delimited JSON (LDJSON). JSON Lines files may be saved with the file extension .jsonl, *.ndjson, *.ldjson.

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 PostgreSQL table to JSONL file - Choose PostgreSQL and logon

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

Export data from PostgreSQL Table To JSON lines (JSONL / NDJSON / LDJSON) - task window

Select JSON file type.

Export data from PostgreSQL Table To JSON lines (JSONL / NDJSON / LDJSON) - select JSON file type

1. Choose PostgreSQL table.

Unload data from PostgreSQL Table To JSON lines (JSONL / NDJSON / LDJSON) - select table

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

Extract data from PostgreSQL Table To JSON lines (JSONL / NDJSON / LDJSON) - enter file name

3. Set rows options.

Convert data from PostgreSQL Table To JSON lines (JSONL / NDJSON / LDJSON) - summary

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

Dump data from PostgreSQL Table To JSON lines (JSONL / NDJSON / LDJSON) - export

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

Export data from PostgreSQL Table To JSON lines (JSONL / NDJSON / LDJSON) - view JSON lines file

More tools for JSONL / NDJSON / LDJSON.