Re: [GENERAL] mirroring table

2008-08-23 Thread searchelite
Craig Ringer wrote: > > It sounds like what you want is to have a table that contains a full > history of records, plus another table that contains only the records > from the first table that were inserted/updated today. > > If that is what you mean, there are several ways to do it, with > di

Re: [GENERAL] mirroring table

2008-08-13 Thread Craig Ringer
searchelite wrote: > Hi all..how can i mirroring table in postgresql? > Let say i have a transaction table updated everyday, i want to mirror that > table so that the other table only store the latest updated day records.. > I hope you can understand my question.. It sounds like what you want is t