Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-novice by date

Next:From: Chander GanesanDate: 2006-10-30 14:12:41
Subject: Re: postgresql tuning
Previous:From: Shane AmblerDate: 2006-10-28 09:03:24
Subject: Re: postgresql tuning

pgsql-admin by date

Next:From: Shoaib MirDate: 2006-10-30 12:49:04
Subject: Re: 100% failover + replication solution
Previous:From: Mensinger, OliverDate: 2006-10-30 12:10:34
Subject: Re: 100% failover + replication solution

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group