insert OS command results into a table on a remote system ? - Mailing list pgsql-admin

From Kevin Kempter
Subject insert OS command results into a table on a remote system ?
Date
Msg-id 201006091010.44437.kevink@consistentstate.com
Whole thread Raw
List pgsql-admin
Hi All;

I want to gather OS command based stats such as the results of commands
like: 'df' 'iostat' 'free' etc and put the results into a temp table that I
can then select from.

I need to do this all from the db since I wont have OS/shell access,
only 'psql -h' access. Is this possible?

Can I somehow leverage the '\!' meta command in psql to pull results of OS
commands into a table?

Thanks in advance...

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fatal Error during PITR Recovery
Next
From: Tim Landscheidt
Date:
Subject: Re: insert OS command results into a table on a remote system ?