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/

postgres reset sequence after import

set a column with value from different table

Last modified 9mo ago