Re: [GENERAL] Shell script to extract a table from a plain text dump

2005-10-08 Thread Christopher Kings-Lynne
Argh! That's some sed coolness :) Chris Martijn van Oosterhout wrote: On Fri, Oct 07, 2005 at 04:46:12PM +0800, Christopher Kings-Lynne wrote: If you have huge plain text dumps, and just want to restore one table it's usually painful. Attached is a small shell script that can take a plain

[GENERAL] Shell script to extract a table from a plain text dump

2005-10-07 Thread Christopher Kings-Lynne
If you have huge plain text dumps, and just want to restore one table it's usually painful. Attached is a small shell script that can take a plain text dump and extract a single table's COPY data commands from it. If people think it's interesting and should be developed, I can pop it on

Re: [GENERAL] Shell script to extract a table from a plain text dump

2005-10-07 Thread Martijn van Oosterhout
On Fri, Oct 07, 2005 at 04:46:12PM +0800, Christopher Kings-Lynne wrote: If you have huge plain text dumps, and just want to restore one table it's usually painful. Attached is a small shell script that can take a plain text dump and extract a single table's COPY data commands from it. If

Re: [HACKERS] [GENERAL] Shell script to extract a table from a plain text dump

2005-10-07 Thread Alvaro Herrera
On Fri, Oct 07, 2005 at 11:36:27AM +0200, Martijn van Oosterhout wrote: On Fri, Oct 07, 2005 at 04:46:12PM +0800, Christopher Kings-Lynne wrote: If you have huge plain text dumps, and just want to restore one table it's usually painful. Attached is a small shell script that can take a