Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Pg_restore is pretty flexible. You can have it generate a list of the objects in the dump, and then edit that file to create/restore only the objects of interest. You can omit/change permissions, schema objects, restore order, etc. You can also specify data only restore as a command line option. If you don't want the index, just remove it from the table definition and do a data only restore on that table.


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: