Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [SPAM] Restore single table from pg_dumpall.
- From: Jim Nasby <decibel(at)decibel(dot)org>
- To: Duncan Garland <duncan(dot)garland(at)ntlworld(dot)com>
- Cc: "Jim Stalewski" <JStalewski(at)VisaLighting(dot)com>, <pgsql-novice(at)postgresql(dot)org>
- Subject: Re: [SPAM] Restore single table from pg_dumpall.
- Date: Thu, 25 Jan 2007 22:42:15 -0600
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(at)nasby(dot)net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
- References:
- Re: [SPAM] Restore single table from pg_dumpall.
- From: Duncan Garland
- Re: [SPAM] Restore single table from pg_dumpall.
- Prev by Date: Re: Windows 2K Installation difficulties...
- Next by Date: pgsql & transaction doubt
- Previous by thread: Re: [SPAM] Restore single table from pg_dumpall.
- Next by thread: Problems w/ Temp Tables
- Indexes: