Cheat Sheet logoCheat Sheet Today
PostgreSQL Backup and Restore Cheat Sheet/COPY query to program

Stream exported data to a server-side program.

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

COPY query to program

sql
sql
COPY (SELECT * FROM public.users) TO PROGRAM 'gzip > /tmp/users.csv.gz' 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
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
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 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