Video: Export data from PostgreSQL table to JSON file in a few clicks

This video shows how to export data from PostgreSQL table to JSON file in a few clicks with Withdata DBToFile, or with the free Export PostgreSQL to JSON online tool. It covers the postgres table side and the JSON side.

Export PostgreSQL to JSON: what this does

This walks through exporting a PostgreSQL table — or a query result — to a JSON file. It is useful when you need to feed PostgreSQL data into a web service, a JavaScript app, or a document store that expects JSON. The video above shows the full flow; the notes below cover the details that matter for PostgreSQL specifically.

Steps

Open Withdata DBToFile and connect to your PostgreSQL database (host, port, database, user).
Pick the table you want, or switch to Query and paste a SELECT — so you can export a subset of rows or a join.
Choose JSON as the destination format.
Set the output file and options, then click Export.
For repeat jobs, save the session and run it from the command line or a scheduled task.

PostgreSQL to JSON: details worth knowing

Type mapping. PostgreSQL numeric/decimal and bigint are written as JSON numbers (or as quoted strings if you prefer, to avoid precision loss in JavaScript); boolean becomes true/false; timestamp and timestamptz are written as ISO-8601 strings.
NULL vs empty string. A PostgreSQL NULL is exported as JSON null, while an empty string stays "". Keep them distinct if the consumer relies on the difference.
Nested types. json and jsonb columns are emitted as nested JSON objects rather than escaped strings, so the output stays valid JSON. Arrays can be written as JSON arrays.
Identifiers and case. Unquoted PostgreSQL identifiers are folded to lower case; quoted identifiers keep their case. The JSON keys follow the column names as returned by the query.
Large tables. For very large tables, export in batches (a LIMIT/OFFSET or a moving filter) — most consumers have to load a single JSON document whole.

FAQ

Can I export only some columns?: Yes. Use a query and select just the columns you need; the JSON keys follow the query result.
Can I run this on a schedule?: Yes. Save the session and call it from the command line or Windows Task Scheduler (a Linux cron job works too).
Does it need a PostgreSQL client installed?: No psql or client libraries are required — the tool connects directly.

Prefer a step-by-step tool page? See Export PostgreSQL to JSON, or the app overview Withdata DBToFile.

Download Withdata DBToFile