From: Murthy Nunna <mnunna@fnal.gov>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Output shell variable from psql
Thread-Topic: Output shell variable from psql
Thread-Index: AdqJx2rhlb+bxp8iQJe5jyuFhnQS6g==
Date: Mon, 8 Apr 2024 15:17:45 +0000
Message-ID: 
 <DM8PR09MB667723C1012EDD032EC1BE22B8002@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?+7mh4xL3l3lCbWFjrN3xIeyeYYC3aSn9MSdYXwOj4lAi4bCDty01sigkX5UB?=
 =?us-ascii?Q?flGLVWwl0EAyBy+oGjSSSFBpZ5K7m0N/iKRE0mCZjLHaJffS6vzDGUveqbXH?=
 =?us-ascii?Q?VvUhaxloFJ5UaC84K07eZuzWWoQXY/3dCxj+sOtXxSZYzh6S+QDa1Wx416TL?=
 =?us-ascii?Q?si59EkZdBxGumVTOH40vg8T6Wy0wiNnV3TiFjEdXe9IQ8YvD39TkdI36bGni?=
 =?us-ascii?Q?oVmIUi4wp9jvzYgI7AZjeIO0MwDobe9YWlukw/WsPo5eX8Chi+m9f+uh4aFB?=
 =?us-ascii?Q?UNP9P8B/HqcfJ6rZJBuAwR12W+VHoOIohgBIJpVRyyytThbhD0GsCz3oVXxZ?=
 =?us-ascii?Q?U6GHmFO1XxPhplquTVtNaSBaFYfbGlI5R34oDVzbaauIgtsrtFcBssJ9IKxp?=
 =?us-ascii?Q?D6tzj/EAQC/lbezsIm++6nfx9GaJ1xpGxjtxjyphEuIIN822Az4psMmnAfEZ?=
 =?us-ascii?Q?PkwgZ1cE4L3zBEy7glicb0hMBZUPa8rCpcCx5Nd79JGI0+SR5peqZcbtQ5wb?=
 =?us-ascii?Q?MWYSPtnvZOkEqo+8V1ovzEaELFWQ00alYnnWGBt2UxHAaBL0zcprCfYBNLzl?=
 =?us-ascii?Q?/Q4PCI3rx7F/ye6NNNQdp2fOxlo4lyR7wriFWUPE+O7Iso3bS/m/jvfaBSGg?=
 =?us-ascii?Q?nHRRmOsEXlDNbimr1apvrfKnCX13DRmLuPVEN/EfwawpAQfSQMsNYI1DWfwG?=
 =?us-ascii?Q?MtC314YQJKFQaISXrgh1KUZlK5XGLtWN+GiTypnCMJWE7LbNCwA4/lD/lZun?=
 =?us-ascii?Q?UT9SvUQPPyJ+/xmShFPAgUg/8glhG51g8r+sZwZssucv6QWnFCg+u9/4z8DX?=
 =?us-ascii?Q?QgFyrS3Lloe8w4v+ubXWy2tnaR2WWHRdZFxylCtCcxJ82mGHlm1+wGKxuKVQ?=
 =?us-ascii?Q?bFFXRevoMiWWk3jr3+yS9g7qQ4arkcddfq8Kk/v5eJWImArOPUpZN6JtcegA?=
 =?us-ascii?Q?rWwu/rlcm1INM3kyLhlD2LqGO0LZYmzMGSh2E89f/jAAcSblujUbADCezKLI?=
 =?us-ascii?Q?Imw/Y09RB41weL3PuSh+krG6t3VBnzubpUu9D5U2gBECEA3hS27QHdS5mYgW?=
 =?us-ascii?Q?5HpKlugs1Ih250ikEWV6WDaNuNems3xMfCseI8F+GPRTbsH4lQPFXASGmnMK?=
 =?us-ascii?Q?KiDpnUBHUVeXxlRA9qFJksRyW7PCXHkx7fO1b7UWzaI0k0Nk3wZuzQKnvMlW?=
 =?us-ascii?Q?Izbu8I+4EZaXaZA0RKEeEHL/g2byU4lmuUybsgCv3deDOLCSeLFgF5glydjy?=
 =?us-ascii?Q?PqD45b08xV3MngNjGkxXRIGS0O6hhof6sxL0Ix2lvRgpADDQQ2ia5YWwR68g?=
 =?us-ascii?Q?OLbj37uLZEX0J+E8ypoH+3iPhesSBUjg/IfLe07hbZHa314D/n457Ff1z5Rm?=
 =?us-ascii?Q?vA0LiS/Sm0dfmk+UjCqWAJAEPiwRdGuKiNa5UUswyf5iK1rpG5y85qppJHyI?=
 =?us-ascii?Q?UlN3mhCBRyCdVqs5nWa6AlH48rGEwa+/x4knqcEz64WU/4RgCvmKcF67V94c?=
 =?us-ascii?Q?szvcQlcp3wL/4GsfVsnH+VnEdygiFMKEeTPgMEERajfnus0qeRRlAm+a07Kh?=
 =?us-ascii?Q?QjLbyGJpd0SCXh0rbEyXk+rbNwXhOgZwHAfP10Aw?=
Content-Type: multipart/alternative;
	boundary="_000_DM8PR09MB667723C1012EDD032EC1BE22B8002DM8PR09MB6677namp_"
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: 
 6c807930-a25a-474f-6338-08dc57df0bac
X-MS-Exchange-CrossTenant-originalarrivaltime: 08 Apr 2024 15:17:46.4389
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 9d5f83d3-d338-4fd3-b1c9-b7d94d70255a
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SJ0PR09MB9555
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/DM8PR09MB667723C1012EDD032EC1BE22B8002%40DM8PR09MB6677.namprd09.prod.outlook.com>
Precedence: bulk

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

Hi,

Is there a way to output shell variable from psql?

export TEST_V=3D7
echo Value is  ${TEST_V}
Value is 7

psql -U postgres -p 5439
\echo Value is  ${TEST_V}
Value is ${TEST_V}

Thanks!


--_000_DM8PR09MB667723C1012EDD032EC1BE22B8002DM8PR09MB6677namp_
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;
	font-family:"Calibri",sans-serif;}
@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">Is there a way to o=
utput shell variable from psql?<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">export TEST_V=3D7<o=
:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">echo Value is&nbsp;=
 ${TEST_V}<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">Value is 7<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">psql -U postgres -p=
 5439<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">\echo Value is&nbsp=
; ${TEST_V}<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:12.0pt">Value is ${TEST_V}<=
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">Thanks!<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>
</div>
</body>
</html>

--_000_DM8PR09MB667723C1012EDD032EC1BE22B8002DM8PR09MB6677namp_--