> For the complete documentation index, see [llms.txt](https://til.yulrizka.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://til.yulrizka.com/db/postgres-skip-table-from-restore.md).

# postgres skip table from restore

Restore done in 3 steps:

1. Generate task list

   ```
   pg_restore -l dump-path/ > task
   ```
2. Edit the generated `task file` and remove the step that we wanted to ignore. Example, if we want to skip the restoring `sometable`, we remove this line from the file.

   ```
   4749; 0 106924 TABLE DATA public sometable someuser
   ```
3. Restore using the task file

   ```
   pg_restore -d somedatabase -L ./task dump-path/
   ```