4 ms·
I think you forgot to finish your sentence. You were about to say how to do it?
by someotheridiot 16y ago
I think you forgot to finish your sentence. You were about to say how to do it?
- dougabug 16y agoPg_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.