On Tuesday 06 February 2007 09:32, Jeff Amiel <becauseimjeff@xxxxxxxxx> wrote: > We just switched from 'pg_dumpall" to "pg_dump -format=c" for our nightly > backups. I wanted to experiment with restoring a single table (if the > need should ever arise) from the dump file. > I also notice that the indexes are not restored...that I understand. I > guess I have to do separate --index for each index on the table, correct? > > Any help would be appreciated. You can extract the full table of contents from the custom dump (pg_restore --list dump_file), then extract just the lines relevant to your table and use those to restore (or at least identify the objects to restore). You'll find the ACL's, indexes, foreign keys and triggers all on different lines. -- Ginsberg's Theorem: 1) You can't win. 2) You can't break even. 3) You can't quit the game.
