Cheat Sheet logoCheat Sheet Today
PostgreSQL Backup and Restore Cheat Sheet/Server-side COPY to CSV

Write a table to a server-side file.

Back to sheetBrowse commands
Sign in to save
Section: COPY Import and Export

Server-side COPY to CSV

sql
sql
COPY public.users TO '/var/lib/postgresql/users.csv' CSV HEADER;
Explanation

Requires superuser or suitable permissions.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing COPY Import and Export
Server-side COPY from CSV
Load rows from a server-side CSV file.
OpenIn sheetsqlsame section
Client-side \copy export
Export via the client machine rather than the database server.
OpenIn sheetsqlsame section
Client-side \copy import
Import CSV from the client machine.
OpenIn sheetsqlsame section
COPY query to program
Stream exported data to a server-side program.
OpenIn sheetsqlsame section
COPY FREEZE into fresh table
Load immutable initial data into a newly created or truncated table.
OpenIn sheetsqlsame section
Custom format dump
Create a compressed custom-format backup archive.
OpenIn sheetbash