Re: table format specification

On Tue, Apr 29, 2008 at 02:19:24PM +0100, "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.

There's the manual which has quite a bit of detail. If you want code
there are pg_filedump and pgfsck which can parse datafiles (as long as
your database is in some kind of readable state).

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.