Convert PostgreSQL table to CSV
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Worth a look
- Spreadsheet File (Spreadsheet File): Convert to File / Extract from File
Nodes used (4)
- Manual Trigger
n8n-nodes-base.manualTrigger - Spreadsheet File
n8n-nodes-base.spreadsheetFile - Edit Fields (Set)
n8n-nodes-base.set - Postgres
n8n-nodes-base.postgres
What it does
Convert PostgreSQL table to CSV CSV is a super useful and universal way to transfer data between different tools. This workflow gives an example of how to take data from PostgreSQL and convert it easily into a CSV. What you need Before running the workflow, please make sure you have access to a remote PostgreSQL server and have table data: booktitle,bookauthor,readdate Demons,Fyodor Dostoyevsky,2022-09-08 Ulysses,James Joyce,2022-05-06 Catch-22,Joseph Heller,2023-01-04 The Bell Jar,Sylvia Plath,2023-01-21 Frankenstein,Mary Shelley,2023-02-14 How it works 1. Trigger the workflow on click 2. Declare the name of the Excel file and sheet names 3. Remotely connect to the PostgreSQL database and specify query execution 4. Write the query data to CSV The detailed process is explained further in the tutorial: https://blog.n8n.io/postgres-export-to-csv/