Re: Run external command as part of an sql statement ?

On 05/07/2018 02:35 PM, David Gauthier wrote:
> 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 ?

PL/sh?:

https://github.com/petere/plsh

CREATE OR REPLACE FUNCTION id() RETURNS text AS '
#!/bin/sh
id -nu
' LANGUAGE plsh;

aklaver(at)tito:~> psql -d test -U postgres

test=# select * from id();
id
----------
postgres

It is an untrusted language so you will need to run as a superuser.

>
> Thanks

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com