Cheat Sheet logoCheat Sheet Today
PostgreSQL Backup and Restore Cheat Sheet/Client-side \copy export

Export via the client machine rather than the database server.

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

Client-side \copy export

sql
sql
\copy public.users TO './users.csv' CSV HEADER
Explanation

See summary for usage details.

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
Client-side \copy import
Import CSV from the client machine.
OpenIn sheetsqlsame section
Server-side COPY to CSV
Write a table to a server-side file.
OpenIn sheetsqlsame section
Server-side COPY from CSV
Load rows from a server-side CSV file.
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
Restore plain SQL dump
Replay a plain-text SQL dump with psql.
OpenIn sheetbash1 tag match