From: "Liz Pelletier" <liz(at)plandepot(dot)com>
> If I have a dump of myDB, and I want to restore only two tables from
> this dump, is there a way to do this? Or do I have to restore the entire
> db?
>
> (BTW, using 7.1 on a Debian box.)
Try pg_restore if you used pg_dump's new option (never tried it myself).
If you dumped your database as text (INSERTs/COPY) it's cut & paste time (or
a couple of greps and a short perl script).
- Richard Huxton