Re: Recovering data via raw table and field separators

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Recovering data via raw table and field separators
Дата
Msg-id 20071204183816.GH4727@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Recovering data via raw table and field separators  ("John Wells" <jb@sourceillustrated.com>)
Ответы Re: Recovering data via raw table and field separators  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: WAL shipping question
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Recovering data via raw table and field separators