Postgres Pro
Downloads
Home   >   mailing lists

Run external command as part of an sql statement ? - Mailing list pgsql-general

From David Gauthier
Subject Run external command as part of an sql statement ?
Date
Msg-id CAMBRECD0cW4mvg_ZfRX=qW8iJanCVjQU+j=Yx5J7jbn4uBSZ2Q@mail.gmail.com
Whole thread Raw
Responses Re: Run external command as part of an sql statement ?
Re: Run external command as part of an sql statement ?
List pgsql-general
Tree view
Hi:

At the psql prompt, I can do something like...
   "select  \! id -nu"
...to get the uid of whoever's running psql.  
 
I want to be able to run a shell command like this from within a stored procedure.  Is there a way to do this ?

Thanks

pgsql-general by date:

Previous
From: "a"
Date:
Subject: How to manipulate tuples in C functions?
Next
From: "David G. Johnston"
Date:
Subject: Re: Run external command as part of an sql statement ?