Quick Links

Re: how can i view deleted records?

From:	Robby Russell <robby(dot)lists(at)planetargon(dot)com>
To:	Dan Black <fireworker(at)gmail(dot)com>
Cc:	pgsql-general(at)postgresql(dot)org
Subject:	Re: how can i view deleted records?
Date:	2006-04-29 23:18:53
Message-ID:	F6A0D1DE-708C-480D-B64A-E830EE011AC2@planetargon.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

On Apr 29, 2006, at 12:49 PM, Dan Black wrote:

> Hello, everybody!
> How can I view deleted records in table?

SELECT * FROM recycle_bin;

;-)

Just kidding... once you delete your records... they are gone.

You could restore your database... assuming that you have a backup.

-Robby

Robby Russell
Founder & Executive Director

PLANET ARGON, LLC
Ruby on Rails Development, Consulting & Hosting

+1 503 445 2457
+1 877 55 ARGON [toll free]
+1 815 642 4968 [fax]

	From	Date	Subject
Next Message	Steve Atkins	2006-04-30 02:05:35	Re: how can i view deleted records?
Previous Message	Tom Lane	2006-04-29 22:39:21	Re: Alternative for vacuuming queue-like tables