Date: Sat, 9 Nov 2024 18:02:03 +0000 (UTC)
From: "Efrain J. Berdecia" <ejberdecia@yahoo.com>
Reply-To: "Efrain J. Berdecia" <ejberdecia@yahoo.com>
To: mnunna@fnal.gov, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Message-ID: <1239230547.604518.1731175323447@mail.yahoo.com>
In-Reply-To: <DM8PR09MB6677887ED1DA5D9494E2055CB85E2@DM8PR09MB6677.namprd09.prod.outlook.com>
References: <DM8PR09MB6677887ED1DA5D9494E2055CB85E2@DM8PR09MB6677.namprd09.prod.outlook.com>
Subject: Re: Bash function from psql (v14)
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_604517_568208966.1731175323446"
Content-Length: 6478
Archived-At: <https://www.postgresql.org/message-id/1239230547.604518.1731175323447%40mail.yahoo.com>
Precedence: bulk

------=_Part_604517_568208966.1731175323446
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Maybe try using full path...

Yahoo Mail: Search, Organize, Conquer=20
=20
  On Sat, Nov 9, 2024 at 12:41 PM, Murthy Nunna<mnunna@fnal.gov> wrote:  =
=20
<!--#yiv2777555521 filtered {}#yiv2777555521 filtered {}#yiv2777555521 p.yi=
v2777555521MsoNormal, #yiv2777555521 li.yiv2777555521MsoNormal, #yiv2777555=
521 div.yiv2777555521MsoNormal {margin:0in;font-size:11.0pt;font-family:"Ca=
libri", sans-serif;}#yiv2777555521 span.yiv2777555521EmailStyle17 {font-fam=
ily:"Calibri", sans-serif;color:windowtext;font-weight:normal;font-style:no=
rmal;}#yiv2777555521 .yiv2777555521MsoChpDefault {}#yiv2777555521 filtered =
{}#yiv2777555521 div.yiv2777555521WordSection1 {}-->
Hi,
=20
 =C2=A0
=20
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 separate script instead of a functi=
on works, but I do not want to do that. I have too many variables to be pas=
sed back and forth. Any ideas?
=20
 =C2=A0
=20
#!/bin/bash
=20
psql -d postgres=C2=A0 -p 5433 <<-PSQLBLOCK
=20
\! run-bash-function=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 -- This doesn=E2=80=99t work
=20
PSQLBLOCK
=20
 =C2=A0
=20
# Run the function outside PSQLBLOCK. This works!
=20
run-bash-function
=20
exit $?
=20
 =C2=A0
=20
# Create bash function
=20
run-bash-function ()
=20
{
=20
=C2=A0 echo "in bash function"
=20
}
=20
# end of bash script
=20
 =C2=A0
=20
 =C2=A0
=20
Run the above script:
=20
./test-bash-function.sh
=20
sh: line 1: run-bash-function: command not found
=20
in bash function
=20
 =C2=A0
=20
------=_Part_604517_568208966.1731175323446
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

Maybe try using full path...<br><br><div id="ymail_android_signature"><a id="ymail_android_signature_link" href="https://mail.onelink.me/107872968?pid=NativePlacement&amp;c=Global_Acquisition_YMktg_315_EmailSignatureGrowth_YahooMail:Search,Organize,Conquer&amp;af_sub1=Acquisition&amp;af_sub2=Global_YMktg&amp;af_sub3=&amp;af_sub4=100000945&amp;af_sub5=OrganizeConquer__Static_">Yahoo Mail: Search, Organize, Conquer</a></div> <br> <blockquote style="margin: 0 0 20px 0;"> <div style="font-family:Roboto, sans-serif; color:#6D00F6;"> <div>On Sat, Nov 9, 2024 at 12:41 PM, Murthy Nunna</div><div>&lt;mnunna@fnal.gov&gt; wrote:</div> </div> <div style="padding: 10px 0 0 20px; margin: 10px 0 0 0; border-left: 1px solid #6D00F6;"> <div id="yiv2777555521"><html xmlns="http://www.w3.org/TR/REC-html40">
<head>
 
 
<style><!--

#yiv2777555521 filtered {}
#yiv2777555521 filtered {}

#yiv2777555521 p.yiv2777555521MsoNormal, #yiv2777555521 li.yiv2777555521MsoNormal, #yiv2777555521 div.yiv2777555521MsoNormal
	{margin:0in;font-size:11.0pt;font-family:"Calibri", sans-serif;}
#yiv2777555521 span.yiv2777555521EmailStyle17
	{font-family:"Calibri", sans-serif;color:windowtext;font-weight:normal;font-style:normal;}
#yiv2777555521 .yiv2777555521MsoChpDefault
	{}
#yiv2777555521 filtered {}
#yiv2777555521 div.yiv2777555521WordSection1
	{}
--></style>
</head>
<div>
<div class="yiv2777555521WordSection1">
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">Hi,</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;"> &nbsp;</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">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 separate script instead of a function works, but I do not want to do that. I have too many
 variables to be passed back and forth. Any ideas?</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;"> &nbsp;</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">#!/bin/bash</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">psql -d postgres&nbsp; -p 5433 &lt;&lt;-PSQLBLOCK</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">&#92;! run-bash-function&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- This doesn&#8217;t work</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">PSQLBLOCK</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;"> &nbsp;</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;"># Run the function outside PSQLBLOCK. This works!</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">run-bash-function</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">exit $?</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;"> &nbsp;</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;"># Create bash function</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">run-bash-function ()</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">{</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">&nbsp; echo &quot;in bash function&quot;</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">}</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;"># end of bash script</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;"> &nbsp;</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;"> &nbsp;</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">Run the above script:</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">./test-bash-function.sh</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">sh: line 1: run-bash-function: command not found</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;">in bash function</span></p> 
<p class="yiv2777555521MsoNormal"><span style="font-size:12.0pt;"> &nbsp;</span></p> 
</div>
</div>
</html>
</div> </div> </blockquote>
------=_Part_604517_568208966.1731175323446--