Re: [ADMIN] Backing Up Partial Databases

2006-10-26 Thread Jim C. Nasby
On Thu, Oct 26, 2006 at 04:08:05PM +0930, Shane Ambler wrote: > >I have two identical databases (primary and backup) and I need to > >transfer a small portion of missing data from one to the other. Is there > >an easier way to do this rather than SELECT-ing the interval then > >parsing the ouput

Re: [ADMIN] Backing Up Partial Databases

2006-10-25 Thread Shane Ambler
Duncan McDonald wrote: Hi All, I was wondering whether there was a way to back up partial sets of data as INSERT statements? Pg_dump seems only to handle whole databases or tables. I have two identical databases (primary and backup) and I need to transfer a small portion of missing data fro