Re: [SPAM] Restore single table from pg_dumpall.

On Jan 23, 2007, at 5:13 AM, Duncan Garland wrote:
> If the dump is in plain text then you need to strip out the surplus
> data and feed the rest to psql. If the file is too big for vi, try
> a stream editor such as sed or a simple perl script.

I find that using less to get line numbers and then using a
combination of head and tail works well. Almost guaranteed to be a
whole lot faster than loading a large file into vi.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)