Cheers for the link, I'll give pl/sh a go too. I was just hoping someone
else may have done it already.
Best Regards,
Tim
-----Original Message-----
From: Lee Kindness [mailto:lkindness@csl.co.uk]
Sent: 25 September 2002 10:39
To: Tim Knowles
Cc: Lee Kindness; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postmaster Uptime
Lee Kindness writes:
> As others have said it is certainly do-able, but you're going to have
> to do it! In the past you've got the uptime using ps - what you need
> to do is wrap this into a script and add it to a database as a
> function (using pg/tcl, pg/perlu, whatever). Or you could do it as a C
> function...
Actually pl/sh would be the obvious choice:
http://www.ca.postgresql.org/~petere/plsh.html
Lee.