| 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: | 2007-01-26 04:42:15 |
| Message-ID: | 4421BD50-D064-413C-A043-EDB985D212ED@decibel.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luca Ferrari | 2007-01-26 07:39:16 | pgsql & transaction doubt |
| Previous Message | Oisin Glynn | 2007-01-25 18:28:43 | Re: Windows 2K Installation difficulties... |