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

From Alvaro Herrera
Subject Re: Recovering data via raw table and field separators
Date
Msg-id 20071204183816.GH4727@alvh.no-ip.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
John Wells wrote:
> On 12/4/07, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> > There are no field separators.  Perhaps you could extract some useful
> > info with pg_filedump, which you can grab at
> > http://sources.redhat.com/rhdb
>
> So is it simply field width? Can one count the number of bytes based
> on native datatype length and determine field start/end?

Yes.  For variable length types, there is a 4-byte length word at the
start of the field (unless you are using 8.3 which introduces more
compact representations in some cases).

--
Alvaro Herrera                         http://www.flickr.com/photos/alvherre/
"If it wasn't for my companion, I believe I'd be having
the time of my life"  (John Dunbar)

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: WAL shipping question
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Recovering data via raw table and field separators