pg_dump -U myapp_user -Fc myapp_db > backup.dump

Category: Self-Hosting

pg_dump -U myapp_user -Fc myapp_db > backup.dump

Export a PostgreSQL database in custom binary format — faster to restore than plain SQL

Exports in PostgreSQL's custom binary format — compressed and faster to restore than plain SQL, but not human-readable.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.