On Wed, 2002-07-10 at 16:20, Lamar Owen wrote:
> On Wednesday 10 July 2002 09:11 am, Hannu Krosing wrote:
> > On Wed, 2002-07-10 at 01:09, Lamar Owen wrote:
> > > The wc utility isn't in the path in an OS install situation. The df
> > > utility isn't in the path, either. You can use python, though. :-) Not
> > > that that would be a good thing in this context, however.
>
> > Why not ?
>
> > The following is wc in python
>
> [snip]
>
> > And I have written custom postgres table dumpers in python without too
> > much effort (except reverse-engineering the page structure ;) for both
> > 6.x and 7.x database tables, so we could actually use python here too.
>
> I'm willing to look into this. However, the dump still has to be pulled with
> a standalone backend -- no networking availability can be assumed.
Actually it works on raw table file ;)
I attach code that dumps data from page file for table of 4 ints all NOT
NULL, like
create table fourints(
i1 int not null,
i2 int not null,
i3 int not null,
i4 int not null
);
the script is meant for quick and dirty resque operations, and requires
that one writes their own data-field extractor code. I have used it
mainly to resurrect accidentally deleted data.
it is for 7.x style pagefile layout
-------------------
Hannu