Convert PostgreSQL table to CSV

Go to Workflow
2,851 views
Built by Alex Emerich Alex Emerich
Created on June 13, 2026

Description

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:

book_title,book_author,read_date
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
Trigger the workflow on click
Declare the name of the Excel file and sheet names
Remotely connect to the PostgreSQL database and specify query execution
Write the query data to CSV

The detailed process is explained further in the tutorial:
https://blog.n8n.io/postgres-export-to-csv/

Nodes Used (1)

Postgres
n8n-nodes-base.postgres