Skip to content
masterclass Buddy
Start learning

PostgreSQL · Command

pg_restore

pg_restore rebuilds a PostgreSQL database from a non-plain-text pg_dump archive. It can restore directly, create a SQL script, select objects, and use parallel jobs.

Last updated

Syntax

pg_restore [ connection-option ...] [ option ...] [ filename ]

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • pg_dump
  • pg_dumpall
  • psql
  • createdb

Source: PostgreSQL: Documentation: 18: pg_restore. Checked 2026-11-03.