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 Ferrari||Date: 2007-01-26 07:39:16|
|Subject: pgsql & transaction doubt|
|Previous:||From: Oisin Glynn||Date: 2007-01-25 18:28:43|
|Subject: Re: Windows 2K Installation difficulties...|