Re: include shell commands in query

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Sebastian Kniat <sebkniat(at)wp(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: include shell commands in query
Date: 2003-06-16 17:26:46
Message-ID: 20030616172646.GB2940@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 13, 2003 at 21:56:23 +0200,
Sebastian Kniat <sebkniat(at)wp(dot)pl> wrote:
> Hello,
> is posible to include shell commands, like ping, into query?
> e.x.
> select current_timestamp, "ping IP_adress" into table table_name

You could write a function to do this, but it probably isn't a good idea.
Usually you want something external to the database to run commands based
on information stored in the database.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-06-16 17:26:49 Re: Finding Current Page Size
Previous Message Sven Köhler 2003-06-16 17:20:51 Re: RE : full featured alter table?