pg_dump -Fc mydb > mydb.dump

Category: Databases & SQL

pg_dump -Fc mydb > mydb.dump

Back up a database in custom archive format

The -Fc custom format compresses the dump and records object metadata, so pg_restore can pick individual tables or restore in parallel. The file is binary and not human-editable. Related: pg_restore -d mydb mydb.dump.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.