Skip site navigation (1) Skip section navigation (2)

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: 2007-01-26 04:42:15
Message-ID: 4421BD50-D064-413C-A043-EDB985D212ED@decibel.org (view raw or flat)
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)



In response to

pgsql-novice by date

Next:From: Luca FerrariDate: 2007-01-26 07:39:16
Subject: pgsql & transaction doubt
Previous:From: Oisin GlynnDate: 2007-01-25 18:28:43
Subject: Re: Windows 2K Installation difficulties...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group