Message-ID: <3AB6683E.5D0C3FEE@tm.ee>
Date: Mon, 19 Mar 2001 22:12:46 +0200
From: Hannu Krosing <hannu@tm.ee>
MIME-Version: 1.0
To: Yiming Huang <yiming.huang@parallel.ltd.uk>
Cc: pgsql-docs@postgresql.org
Subject: Re: delete - is there any way to recover rows deleted from a table.
References: 
 <79BC7644A8501E4BB560D395FAECD30D0743B5@nic-nts1.nic.parallel.ltd.uk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Yiming Huang wrote:
> 
> Hi,
> 
> I was told that a delete command does not delete  data from a table
> physically.  Is it correct? If it is true, could anyone to tell me whether
> there is a way to recover to data deleted from a table?

In the "original" postgres (not postgreSQL) you could just tell the
backent 
the time interval you were interested in retrieveing. 

Currently It is not so easy, But the data is physically in the tables
until 
you do a VACUUM;

If you are desparate, I can send you some python code to get all data
(both 
deleted and not) from the table. It gives you raw tuples - you have to
write 
code to extract fields from tuples yourself.

---------------
Hannu