Home / server / Questions / 806271
Accepted
user2375592
Asked: 2016-10-01 01:15:43 +0800 CST

pg_restore on a single table not restoring indexes

  • 772

If I use pg_restore to restore the complete database I get all indexes for the tables. But when I try to import a single table there are never any indexes.

to backup i run

pg_dump -Fc -w database > my_database.dump

to restore a single table i run

pg_restore -t table_name -s my_database.dump

Which only returns the create table statement and missing the indexs, where am I going wrong?

postgresql

1 Answers

  1. Best Answer

    If you use -t, you limit the operation to the table you named. Indices are different objects and need to be selected with the -I (or --index=) selector.

    • 5