postgres skip table from restore
pg_restore -l dump-path/ > task4749; 0 106924 TABLE DATA public sometable someuserpg_restore -d somedatabase -L ./task dump-path/
Last updated
Restore done in 3 steps:
Generate task list
pg_restore -l dump-path/ > taskEdit 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 someuserRestore using the task file
pg_restore -d somedatabase -L ./task dump-path/Last updated