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 
> do***entation 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 Lin****angas
   EnterpriseDB   http://www.enterprisedb.com

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers