On Sat, 9 Nov 2024 at 23:11, Murthy Nunna <mnunna@fnal.gov> wrote:
> I am trying to code bash function and call it from psql. But it is failing. How can I get this to work. Creating a
separatescript instead of a function works, but I do not want to do that. I have too many variables to be passed back
andforth. Any ideas?
> Run the above script:
>
> ./test-bash-function.sh
>
> sh: line 1: run-bash-function: command not found
>
> in bash function
>
>
/*
postgres@ubuntu:/tmp$ echo 'whoami' >> myscript.sh
postgres@ubuntu:/tmp$ chmod a+x myscript.sh
postgres@ubuntu:/tmp$ psql <<EOS
\! bash /tmp/myscript.sh
EOS
postgres
*/
--
Thanks,
Vijay
Open to work
Resume - Vijaykumar Jain