"Andreas 'ads' Scherbaum" <adsmail@wars-nicht.de> writes:
> On Tue, 10 Feb 2009 11:36:38 -0500 Bruno Lavoie wrote:
>> Oracle Flashback Query seems to use undo logs to return in a point in
>> time if the undo retention param permit it. You can do it with a date,
>> or with the SCN (system change number), a kind of transaction number. It
>> saves you administration task and table management, and *space*.
>>
>> Is this doable with PG, using some pg transaction logs?
> I think, the only way is to use PITR and roll the backup forward during
> the exact point you want to see.
contrib/spi/timetravel might be worth looking at too. It hasn't been
touched in awhile but AFAIK it still works.
regards, tom lane