Re: table format specification

PontoSI - Consultoria, Informática e Serviços LDA wrote:
> I'm writing a small program to recover specific tables from a severely 
> crippled database, and while I'm able to identify most fields on a hex 
> dump of the table file, there are several 'gaps' (probably headers and 
> footers and/or additional info) that I can't identify. Where can I find 
> documentation regarding the table file layout? I'm working with files 
> generated with Postgres 8.25.

The file itself consists of 8k pages. src/include/storage/bufpage.h and 
src/include/access/htup.h would be a good place to start on 
understanding the page layout. There's also a chapter in the manual 
about it.

You might also want to take a look at the pageinspect contrib module, in 
8.3.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com