From: Murthy Nunna <mnunna@fnal.gov>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Bash function from psql (v14)
Thread-Topic: Bash function from psql (v14)
Thread-Index: AdsyzojsqiDclhyMT/+2qpeBPhPW3A==
Date: Sat, 9 Nov 2024 17:41:02 +0000
Message-ID:
 <DM8PR09MB6677887ED1DA5D9494E2055CB85E2@DM8PR09MB6677.namprd09.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?us-ascii?Q?pJYJqC3zQopo2aGKfeOj2rCUM5RpvQTuf3dzNac/WAA63l3rgMKUfyb5Kx1G?=
 =?us-ascii?Q?rnsNBbkHTAlOOz6hYok3IbkuE/QVnBREqkTmOjOQbJGjQiaI69qwICo2PYfQ?=
 =?us-ascii?Q?LPX6T+jC/uyrOd1GHjZqkUgewA8k5vaWn62rSuYttHLd2pR3tqMYXunHf0HI?=
 =?us-ascii?Q?HqjOjCoHvY3qi5VP92GF+hup4Qu9uFzRsGlUWYAdMWVB212uDrf6HRr67BIO?=
 =?us-ascii?Q?44hoRPAx97WOTPi2Sg9xKXSAFD+T0sOE9XWwcypZeQwH30q/dPEUjWD+RUQI?=
 =?us-ascii?Q?6KZftLQgJVOX8K00Y+YTyG7parVHB4mCJKFsnnlX8rekAO5Zh+YH4Oxxt21X?=
 =?us-ascii?Q?yX8B4FtZiOLKTOcpoq77WaKEKlPhTVhjiYRvVJdorF9KoU37lXVUXOYD1gKf?=
 =?us-ascii?Q?X2eSdR+C+rL7wN/jynzOPmJF+Ep2I1/tKMytnJj7fKI+l5TurHiboGYSovbN?=
 =?us-ascii?Q?HnjaogL13RhuwwY7thVtimqiNxemMezA8VQWsMkT8ufcNpktE0foXuvgWuou?=
 =?us-ascii?Q?+sYmAlFnwPthzHTMJA2DEXLs6Fu5VJLZE1vHWWuy7BnFUhOmp1ZXiRGZ6nN/?=
 =?us-ascii?Q?iysTMexp3l7ta0r4q41QhcR4EyX835u9ULD1FAZU0YIQ+3lfiuqOUGSLJ4p6?=
 =?us-ascii?Q?KBc8ecQ6lN2I/9awcmEXnBc1++plpgWf0NGySMlVXXzzwvHKp/b4Lowq00jX?=
 =?us-ascii?Q?8mpvkyR8U07K2O9uLVy6yaPVCxPLodUaD1IEEGWM9vXh9uWSdtimNNysdlFd?=
 =?us-ascii?Q?yl0ZkGKMnO92zUAV661popSs78X/z0IFs0zwqmmGEY/oZq0sLU9QodgH0mve?=
 =?us-ascii?Q?THl4Z+66rdWvo43oAuV2Vd0ksb2mLlbf3VQyi78m9SNt1/j0ejcz4LX6EByP?=
 =?us-ascii?Q?VQw65MHK6ERC0y/RVdC1CKQzp5UxnrAYbu2Y0/BJcweaYpWV+GNNjfar7jTC?=
 =?us-ascii?Q?vMoE4IilorxxsV/2qgjHDEJ9jJkpKUKJFhA/J2l+OqY6m4Jr/RyyF8db7QT5?=
 =?us-ascii?Q?y7ZMJwFG4yotLc+PL1j1USnUHGer8v1RK0a/sA8y+W/bY6u+gMCjr1EE2lkS?=
 =?us-ascii?Q?zKB8KAFxfBR3mCTES06DtZr/ehDw3hPy71PRL1zS6UnOQ34U84YXZlbYAXgm?=
 =?us-ascii?Q?lYs5Rd7q68OFI6xUJPJzAwi5J1lYLPMbVtsKO4TQy1gGk8FgqzMWgmx80hgD?=
 =?us-ascii?Q?JIq1ONL283vPfehC4TPZ/BEveDHM++WVEujr61Zy0dOI0xN4EAYcrYSgzS2t?=
 =?us-ascii?Q?g9WDqkd2qJZnS6mNIHOL0cmz6YxUUB6QSz63jFhqDGKzek1CcbY30h5wWhXt?=
 =?us-ascii?Q?CT8DGL6UjbsV+CSj+K21ySZgK7SpR7RoxDVvVerDQTF9AOkBH2ZvGAAi2Wd0?=
 =?us-ascii?Q?AJbND735RVSHcZZjEghJC6e+AfMSo/pCArT29rVFUtEA10hqYw0zxBGC+Y93?=
 =?us-ascii?Q?q+NCOJbThkIDbODysVuVRs7+kCarxPcnS6+cll6q7JDCm7r6AL7FYaFvk832?=
 =?us-ascii?Q?muH1vu/tCtbiuIgEC1KjfnAcDwWR2j/zcu8UJB0xamhGCs0idPMzwrwD6SDa?=
 =?us-ascii?Q?4HNg3ltd+mFvTi1TjGJNh8y2au5w1XftqYvZ+DXo?=
Content-Type: multipart/alternative;
	boundary="_000_DM8PR09MB6677887ED1DA5D9494E2055CB85E2DM8PR09MB6677namp_"
MIME-Version: 1.0
X-OriginatorOrg: fnal.gov
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: DM8PR09MB6677.namprd09.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 0547ffce-2232-4891-37e3-08dd00e5ae5a
X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Nov 2024 17:41:02.8728
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 9d5f83d3-d338-4fd3-b1c9-b7d94d70255a
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ0PR09MB11460
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/DM8PR09MB6677887ED1DA5D9494E2055CB85E2%40DM8PR09MB6677.namprd09.prod.outlook.com>
Precedence: bulk

--_000_DM8PR09MB6677887ED1DA5D9494E2055CB85E2DM8PR09MB6677namp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

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?

#!/bin/bash
psql -d postgres  -p 5433 <<-PSQLBLOCK
\! run-bash-function                                        -- This doesn't=
 work
PSQLBLOCK

# Run the function outside PSQLBLOCK. This works!
run-bash-function
exit $?

# Create bash function
run-bash-function ()
{
  echo "in bash function"
}
# end of bash script


Run the above script:
./test-bash-function.sh
sh: line 1: run-bash-function: command not found
in bash function


--_000_DM8PR09MB6677887ED1DA5D9494E2055CB85E2DM8PR09MB6677namp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-ligatures:standardcontextual;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;
	font-weight:normal;
	font-style:normal;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-US" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">Hi,<o:p></o:p></spa=
n></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"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?<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">#!/bin/bash<o:p></o=
:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">psql -d postgres&nb=
sp; -p 5433 &lt;&lt;-PSQLBLOCK<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">\! run-bash-functio=
n&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp; -- This doesn&#8217;t work<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">PSQLBLOCK<o:p></o:p=
></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"># Run the function =
outside PSQLBLOCK. This works!<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">run-bash-function<o=
:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">exit $?<o:p></o:p><=
/span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"># Create bash funct=
ion<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">run-bash-function (=
)<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">{<o:p></o:p></span>=
</p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">&nbsp; echo &quot;i=
n bash function&quot;<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">}<o:p></o:p></span>=
</p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"># end of bash scrip=
t<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">Run the above scrip=
t:<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">./test-bash-functio=
n.sh<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">sh: line 1: run-bas=
h-function: command not found<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">in bash function<o:=
p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt"><o:p>&nbsp;</o:p></=
span></p>
</div>
</body>
</html>

--_000_DM8PR09MB6677887ED1DA5D9494E2055CB85E2DM8PR09MB6677namp_--