I would like to restore selected (currently after
-t) tables including all indexes without making a definition after
-I - because indexes are changing, new ones are created, old ones may expire.
What is the best way to perform the restore process in Postresql db?
I have read that is possible to restore whole db, and then delete unnecessary tabels.
I'm afraid that the process will be much longer and will load the database too much.
-t - recreates only data
-I - I have to define index by myself, I want it to happen automatically