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 to look like INSERT statements? > > > > I can think of a couple of ways - > > COPY (SELECT * FROM myPrimaryTable WHERE id<200) TO '/tmp/myData'; Only in 8.2...
> the --inserts option of pg_dump will export as INSERT's if that is the > way you want to do it. You will need to do a find and replace on the > INSERT's to change the table name though. Though, I don't see any reason you'd want to do that; just stick with the pg_dump defaults. Another option is to use dbi_link. -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
