From: Hannu Krosing <hannu@tm.ee>
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.
Date: Mon, 19 Mar 2001 22:12:46 +0200
Message-ID: <3AB6683E.5D0C3FEE@tm.ee> (raw)
References: <79BC7644A8501E4BB560D395FAECD30D0743B5@nic-nts1.nic.parallel.ltd.uk>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: hannu@tm.ee, yiming.huang@parallel.ltd.uk
Subject: Re: delete - is there any way to recover rows deleted from a table.
In-Reply-To: <3AB6683E.5D0C3FEE@tm.ee>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox