pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feeddelete - is there any way to recover rows deleted from a table.
2+ messages / 2 participants
[nested] [flat]
* delete - is there any way to recover rows deleted from a table.
@ 2001-03-19 11:23 Yiming Huang <yiming.huang@parallel.ltd.uk>
0 siblings, 1 reply; 2+ messages in thread
From: Yiming Huang @ 2001-03-19 11:23 UTC (permalink / raw)
To: pgsql-docs
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?
Cheers,
YiMing
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: delete - is there any way to recover rows deleted from a table.
@ 2001-03-19 20:12 Hannu Krosing <hannu@tm.ee>
parent: Yiming Huang <yiming.huang@parallel.ltd.uk>
0 siblings, 0 replies; 2+ messages in thread
From: Hannu Krosing @ 2001-03-19 20:12 UTC (permalink / raw)
To: Yiming Huang <yiming.huang@parallel.ltd.uk>; +Cc: pgsql-docs
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-03-19 20:12 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-03-19 11:23 delete - is there any way to recover rows deleted from a table. Yiming Huang <yiming.huang@parallel.ltd.uk>
2001-03-19 20:12 ` Hannu Krosing <hannu@tm.ee>
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