Re: Recovering data via raw table and field separators - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Recovering data via raw table and field separators
Date
Msg-id 20071204194757.GD19536@svana.org
Whole thread Raw
In response to Re: Recovering data via raw table and field separators  ("John Wells" <jb@sourceillustrated.com>)
Responses Re: Recovering data via raw table and field separators
List pgsql-general
On Tue, Dec 04, 2007 at 02:26:21PM -0500, John Wells wrote:
> Wow...interesting idea...but to clarify, I copied the table file
> *after* the delete was run on the table. Although the data appears to
> still be there, wouldn't they be marked as deleted in some way and not
> appear in the new table even if the copy worked?

Ah sorry, I though you meant de table was dropped or the database was
deleted. If you actually ran a DELETE FROM on the table, then yes
they'll all be marked deleted.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

Attachment

pgsql-general by date:

Previous
From: SHARMILA JOTHIRAJAH
Date:
Subject: Re: WAL shipping question
Next
From: "John Wells"
Date:
Subject: Re: Recovering data via raw table and field separators