pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
invoke an external shell script from a function
3+ messages / 3 participants
[nested] [flat]

* invoke an external shell script from a function
@ 2000-09-29 15:15 Chau, Artemis <artemis.chau@intel.com>
  2000-09-29 16:31 ` Re: invoke an external shell script from a function Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Chau, Artemis @ 2000-09-29 15:15 UTC (permalink / raw)
  To: pgsql-sql

Does anyone know how to invoke an external shell script from a function when
it is called from a sql statement?

-- Artemis Chau, Intel Corp.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: invoke an external shell script from a function
  2000-09-29 15:15 invoke an external shell script from a function Chau, Artemis <artemis.chau@intel.com>
@ 2000-09-29 16:31 ` Peter Eisentraut <peter_e@gmx.net>
  2000-09-29 23:20   ` Re: invoke an external shell script from a function Joel Mc Graw <jpmcgraw1@home.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Peter Eisentraut @ 2000-09-29 16:31 UTC (permalink / raw)
  To: Chau, Artemis <artemis.chau@intel.com>; +Cc: pgsql-sql

Chau, Artemis writes:

> Does anyone know how to invoke an external shell script from a function when
> it is called from a sql statement?

If it's a C function, use system("file").

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: invoke an external shell script from a function
  2000-09-29 15:15 invoke an external shell script from a function Chau, Artemis <artemis.chau@intel.com>
  2000-09-29 16:31 ` Re: invoke an external shell script from a function Peter Eisentraut <peter_e@gmx.net>
@ 2000-09-29 23:20   ` Joel Mc Graw <jpmcgraw1@home.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Joel Mc Graw @ 2000-09-29 23:20 UTC (permalink / raw)
  To: ; +Cc: pgsql-sql

Peter Eisentraut wrote:
> 
> Chau, Artemis writes:
> 
> > Does anyone know how to invoke an external shell script from a function when
> > it is called from a sql statement?
> 
> If it's a C function, use system("file").

Is this the only way to do this?  I would also like to have a trigger
call an external program.  Is there a good place to go for more info on
this?

TIA



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2000-09-29 23:20 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-29 15:15 invoke an external shell script from a function Chau, Artemis <artemis.chau@intel.com>
2000-09-29 16:31 ` Peter Eisentraut <peter_e@gmx.net>
2000-09-29 23:20   ` Joel Mc Graw <jpmcgraw1@home.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox