Re: [SPAM] Restore single table from pg_dumpall. - Mailing list pgsql-novice

From Jim Nasby
Subject Re: [SPAM] Restore single table from pg_dumpall.
Date
Msg-id 4421BD50-D064-413C-A043-EDB985D212ED@decibel.org
Whole thread Raw
In response to Re: [SPAM] Restore single table from pg_dumpall.  ("Duncan Garland" <duncan.garland@ntlworld.com>)
List pgsql-novice
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)



pgsql-novice by date:

Previous
From: Oisin Glynn
Date:
Subject: Re: Windows 2K Installation difficulties...
Next
From: Luca Ferrari
Date:
Subject: pgsql & transaction doubt