On Thu, May 29, 2003 at 17:37:19 +0800, Abdul Wahab Dahalan <[EMAIL PROTECTED]> wrote: > How can I undelete the deleted data from a table;
If you notice before you commit, you issue a rollback. Otherwise you need to recover from backup. If you don't have a backup, then you might be able to do some fancy stuff to see old tuples. If you are going to do this you should shutdown the database and make a copy of what you have. If you haven't done a vacuum since the delete, the old tuples should still be stored in the database. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
