Re: [ADMIN] Copying data from table to table (cloned tables)

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: shaik mastan dilshad <dilshad_sm(at)rediffmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [ADMIN] Copying data from table to table (cloned tables)
Date: 2006-10-30 12:41:17
Message-ID: 742794.76983.qm@web31810.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-novice

> Can any one tell me,how to retirve the data which had deleted for an instance ,i mean how to
> rollback the previous.

To get the functionality of a rollback you next to begin with a transaction:

begin transaction;

delete from foo;

--oops I deleted to much;

rollback;

Regards,

Richard Broersma Jr.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shoaib Mir 2006-10-30 12:49:04 Re: 100% failover + replication solution
Previous Message Mensinger, Oliver 2006-10-30 12:10:34 Re: 100% failover + replication solution

Browse pgsql-novice by date

  From Date Subject
Next Message Chander Ganesan 2006-10-30 14:12:41 Re: postgresql tuning
Previous Message Shane Ambler 2006-10-28 09:03:24 Re: postgresql tuning