Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1us3tJ-00GqQ2-UJ for pgsql-admin@arkaria.postgresql.org; Fri, 29 Aug 2025 18:32:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1us3tJ-00C4GS-AR for pgsql-admin@arkaria.postgresql.org; Fri, 29 Aug 2025 18:32:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1us3tI-00C4GK-RX for pgsql-admin@lists.postgresql.org; Fri, 29 Aug 2025 18:32:01 +0000 Received: from mail-southcentralusazlp170100001.outbound.protection.outlook.com ([2a01:111:f403:c10e::1] helo=SA9PR09CU002.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1us3tG-002PXx-2R for pgsql-admin@lists.postgresql.org; Fri, 29 Aug 2025 18:32:00 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=S3fnispQOZqOP+Uckd0ciHhv7H7tjmMreEkYEDYVTB3pHw/ql8lZTeLERhb5t1+dBzm8vtEl2U9mu3u0ikO0fDbxun/z9C7Q1/KxWgdHaBnpNu0idiJ69bbmBZ7OWfM6Trj5nJ9gPhhR0IAQFIhW+7u14BdjlOopW1wAmO2TWrX/EWAXPxYnTwhA4VG25uwUwjZomSN5giEDYWZ5hJxCcQ/LO3PWuRFGOqcZ5dDh46ixA82BsohH8i1WNLu+0EAjkpkeeL2fkl/5BQCKJ5tRw1NYst10Z5mIDXwI3ZgEram2IBJPLHcRWPl2aKllxcj4wf3xe4oqRoUH9/HWv27rFw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=kriUWEfvAN7nxI574dSZ3BGUlnbaG5Pgt5EKuFD58Ao=; b=WQZqcScMuXpzQjAR7SR/SZNaPDiNCYAsyLnj+iq+0RTSR/qKRqFWnDjzgkXtoXRLzcqVxJltYMKzRLKvzk5st4Zx4BfyuUy7i5L2TWtgeW+x5bsjZf2yy0j+I/jD7emhMAGkXK12GqFyoxlOSJp5WpVq+bwGQzSu5SQJGiFfqPGzW7gcgn6/eTzoA2cFEFK/+bzWqe5iO6jU+dOEgFOj+/6jdA4YJrO6AOZJAJnOP1ihRvUuvFNzeDvMAdk3U42XG+B6baJbxDXnw0y3N63Vsew9wMfbZa3YFWOAV3YJ+Tpdx1Mw2SHCngAQ/x8OLs7ICMp1NX7DvIp1YdNElpX9fQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=fnal.gov; dmarc=pass action=none header.from=fnal.gov; dkim=pass header.d=fnal.gov; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=fnal.gov; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=kriUWEfvAN7nxI574dSZ3BGUlnbaG5Pgt5EKuFD58Ao=; b=sudsAVYyCa1sWkzbNd5SgAasMP133dynr2h+dZyY8RxX1cw9w4pM5Nyr/KOiY7noxfR8Q9H8SsalHtATJyEG0w58wpcVcbtNfI1ZJSzzN0yUQK8vxZEgpGxXAyUamMsekuoFygvGPYfzZd9PDUlJet7ckrttXQyJ9vQudJPM1HEcQ0Hm5ZK7Xh42g8fNWkNBbUm07RQNYTp7wL5b0gVu00jWlbgHGiYuptNxBH3Jws3J5+wCj2iZFZ4zegstTvYvnjhk3uMtdbKewqKwmUQ73oxdWer1FQl1iMgCzWdXmiqXReIE+wh3F5txAufcXcDTZ2XL6F/gi+Xn+ckE6suyMA== Received: from DM8PR09MB6677.namprd09.prod.outlook.com (2603:10b6:5:2ee::12) by SA1PR09MB11260.namprd09.prod.outlook.com (2603:10b6:806:36c::18) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9073.21; Fri, 29 Aug 2025 18:31:52 +0000 Received: from DM8PR09MB6677.namprd09.prod.outlook.com ([fe80::cdab:8e31:245:e366]) by DM8PR09MB6677.namprd09.prod.outlook.com ([fe80::cdab:8e31:245:e366%3]) with mapi id 15.20.9073.021; Fri, 29 Aug 2025 18:31:52 +0000 From: Murthy Nunna To: Tom Lane CC: Pgsql-admin Subject: RE: Having trouble passing a shell variable to a query from psql command line Thread-Topic: Having trouble passing a shell variable to a query from psql command line Thread-Index: AdwZDD0W5H2GqrYcR92a7c0xEBctswAAjnaAAACjnoAAAIIp0A== Date: Fri, 29 Aug 2025 18:31:52 +0000 Message-ID: References: <2335799.1756491381@sss.pgh.pa.us> In-Reply-To: <2335799.1756491381@sss.pgh.pa.us> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=fnal.gov; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DM8PR09MB6677:EE_|SA1PR09MB11260:EE_ x-ms-office365-filtering-correlation-id: 51ddd1ab-2534-43d9-9526-08dde72a52f8 x-fermilab-ob: 1 x-fermilab-sender-location: inside x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|1800799024|38070700018; x-microsoft-antispam-message-info: =?utf-8?B?RDBYVCttNlExL3Ruem9WbWtXM0RRZjh3RnFYd3BOYm5hSHFrL1Q4cnNVUHN3?= =?utf-8?B?UFJDTDFQcTNxQmZDWVZpT1VtckNBWUFnTWFRTUlrU2JGVDlBTFpYZFF2cUxj?= =?utf-8?B?cFZMMmxPSVJXcDdiSDhOSTFJSGV2a3RSdEtUN0syZ1NvSVhxcnF2RExqcXZh?= =?utf-8?B?MitaS0FLdUlydjBsYVlqZUc1dGNza1VTNkk4ejBJWFJONDVRd3FXWHp5elJH?= =?utf-8?B?SlhkczRMeXRhMGhXNVAzd0xObWlDb1doNDdIMm9qa0JRT1RVaCtzc2JOM2oz?= =?utf-8?B?aitHS2VrMFd6aEhCSEFXNVdUQXhXMzc4Z0hvNFdWMFpxY2hNTDZlalIxQTlu?= =?utf-8?B?OVM1MHQ3VFVhb3F3KzV4TEFBbU8zWXpDL2J6M1Z6WU1paHZoS2ZPaURac0VP?= =?utf-8?B?TjZadDZKcGhmNjI0d1Y1N0JGdmxDbzk5cFZ5a1RaWFplZy9hY0t0V05aSzRi?= =?utf-8?B?MWtaUTFoeVVxcG9ZTFJvVkh0KzNWa1EyS29ESGJCNkl5eUVMYS9PSmlQSldG?= =?utf-8?B?dHYvSlNkNTZUR1lPekYxcWN3RnRoMjl1TzM2OUJiS1pPeU43RTgwZWpnVUVL?= =?utf-8?B?WlgwR2ZDUTVxTjVvN1p4b2xkeXdPNVZPbHJodTN0ektCamt3ZVZsemhUNk1j?= =?utf-8?B?amhVUW0zTzJCMmNoL1ZmTU1FMlVDb1o1TEhScUJ1QmlydmxGaW95QmhYam1p?= =?utf-8?B?dHhaenRHUG80MzBSdC94ZFNTY2VucmMreDVpOE9EaThTazlVRnQrV0N1bG5u?= =?utf-8?B?Mkc0c3RQRWtmWnA0OTJ4Rk5BcFpFekt4RkZzejZSVURHVWhTbENoMDUwcXNB?= =?utf-8?B?WTVHc2N1UE5IcWZtaUd2RmVHSkdCODNOQmdod1hmSGVFNmZuNVVLYzVoVmRU?= =?utf-8?B?TCtVQnR3UUxmb1RHNnBFMVMxd2lFREJHcVFySHNMOTN2dlkwMWNMNlNWNXVV?= =?utf-8?B?MjhqaGhqT3dSMU5rNlBjUi9iMVkreHNDVjBpT1QwNitSc2Z4MkNobDY4TTlU?= =?utf-8?B?K1pPU1M5U2x6ZnpxSWtYNmNzUjFQTHY0RlRkdGRUejNWZlU0SHJ6NmtQdzEv?= =?utf-8?B?WVpWbHRaRWtjYmJJSWc4a1g2QTZndStwSXYwRENrcE9TVzhpTFVpdWlxSWtm?= =?utf-8?B?RTJnemg3VkRsZlJYdlNaa2dXK3c0YzFJdTZaL2VCWGJNbXl1MzFWRzNzSHYz?= =?utf-8?B?RnZnM2Vqczlhbmljb1Q3aEtGNlFpcE9TMEVFZ1JRdE1HUXFiUHdWR0hXb3lo?= =?utf-8?B?cDBnWXBrcHJ0UVQxWWNUdnlreUdKMlFYeGRYTmhleDdMMXU0YWNraElyT01z?= =?utf-8?B?WFEzQUE3eHZTZFpzZStLeXh2OS9Tc2V5VGswTjVDQjRoNVVRNURQUmVXTWNt?= =?utf-8?B?eFRNR00rNlJoUzRmVTVFOXJMNkttZ2VwQ3Z1VW96N1Iwb21xTXduN08ySjAw?= =?utf-8?B?S0hxRCtUd2swWlVyNmFTVmdvRlgra0NVQVJZRGY4dUJVZkVXVkhXSllybVRx?= =?utf-8?B?UEYrRlpiK05jUDdpS25lYlZlU3V4aW5XN2k3UXRDdFo0ZExKb1VJVzA3Unhw?= =?utf-8?B?Z1RRRVMxeGR3TlBGWnNTeDlkR1MrWVgrV1c5bGFmam5CSjF0TURBeGkrRVRa?= =?utf-8?B?Nm9FQXlBaUdqd3hhQ3cyZzlDTk9VK1NLUlNqbDcxdkFkTnpuZmc2d254VFVG?= =?utf-8?B?RVBNNWpPZTdLYmswbkxZY2tEQytmUW04aDJlSXVjc3duR291S3Z1eEluREtw?= =?utf-8?B?K0FRWEtTdFc2eEV5Q3lSQkVid2xURFFFYW1zd2VjSGlOM2s3V1VIcmZ5bEdV?= =?utf-8?B?N0xzN1NZNGMzdGh3cVJ4a2hDVjZSZEFMUXNDWk8xRXY0UlYybGZHa2xBQ0xt?= =?utf-8?B?U2crZUtVV0pQc3JVK2lRUjV1amwzaXVjb3RIYnRhTDhYRHNWK29NMUpUNXlP?= =?utf-8?B?NXo0TWFGQm5ZajRiMnVMbHE3Yy9kb3d4V2x1cUlvR0dEZ2g4R05MdTQ5Y05w?= =?utf-8?B?bWx6WnpNS1BnPT0=?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DM8PR09MB6677.namprd09.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(366016)(1800799024)(38070700018);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?utf-8?B?dXMyYU52ZEVxZmtTQnF4ODlnRVpCdFdPSjNkUjlVNjVxSzFTclJNS3J3Rmtk?= =?utf-8?B?Zm5ndkxtck9tZndLVHp1Ym9oWmJyckZzK2Q4NUtkcDhlaW1YY0Jwa0h2dDly?= =?utf-8?B?Vy9nLzk0aWRZYTNYYTY5eFQrMTl2NU04L0VxSzlsQzkrMXpZNlZ6MDBhV3hN?= =?utf-8?B?cEVQRUZ1SmIxV3hIV1hNb2JXOHpBa3pUN045NitoNURIRk1NSlduMFJhTFMv?= =?utf-8?B?VjRBUG1pMUJha25VbEgyMHBndEpaV3RuUW9qUU5KV3ZoSktiMDBiZGNzaVNx?= =?utf-8?B?L0Z0MXZFNStIK00yTnFJT0VHVE9iRG1TbEFKZVdzbDMzditRNVBpYkloMTRx?= =?utf-8?B?WDF0NDcrVWtlVDRUdGdKNW13Ynk3Y08yL1BuZjhwOVdXaVhOMXRwQ0owU0h4?= =?utf-8?B?NGw3djc1SnA0b0I2NFFjOGlCRkV5TFY0VXBMbFIwa3lCZG41V3NWcmZTWFNl?= =?utf-8?B?cXA0cy9zYmdTZTVoSkRwL3l6Vyt2V1hBRUo0MmcrWXV0OTFOckcyVFVNVzcy?= =?utf-8?B?eGltMHVvZVowME91M1ptOXF5K1RPUUZFRjBnQUk4c2o5REk1ZXJ2UVlHblFD?= =?utf-8?B?WkRIWUZveVVCaHhnSCttMjBxNHBabDcvdVNIMmhyb0F6QTVxNCtLMkhjME9R?= =?utf-8?B?a3M2Znl0dEx3M2hyV1lIa1FKWC9kNVR4YllGVUY0V2pXdW1rd1Q5WEVLVUc0?= =?utf-8?B?K0ZYMzV1YWJmbWRjWnlKRkhYeFBlWndza2ZyTWl0UkoyZ3N1WEgxaHdOcnVa?= =?utf-8?B?aVI2QktQMmlsVS91VVI0UFpIa2hBRmorb3lWVWJjQnhEcVFSaERzVVNpUmlR?= =?utf-8?B?bVQ0VDgwN2ZBQ3FhTXZFcHhFY3FSQmdUR29LNys0cjF0MXZ2Uk9SaVllZTNX?= =?utf-8?B?ZGNWSkRLcXN6T00wNGdocGZNOXkwMHluZ25TWjZveEhGQ3k5cGdQZnFDcnVx?= =?utf-8?B?TldwMytyMmdUQjQrdUJUdG44Y2NueU1XRTZSaFlyM3JCWUI5TEErMG1YV2Mr?= =?utf-8?B?bGZSU2RHRFJrbHhBdzFOMWJKbWV5SlI4QzhWZzl4VVhncGJjMnVRNWZpMEhq?= =?utf-8?B?T2dVUTExeVl6ekEzSFZJNXBLWGZQb3lIWUxOQnZ2dXZrenVua3R6eWhEa0ll?= =?utf-8?B?TWoyYTVjdHMwMjROYk1mTmtRU2FIT1R0T2cvdi8wZjluYlluMlQwc2Y0YWdt?= =?utf-8?B?MUxEOXEzcVlsUmxFT2hBOGtUcnEwZXgzR2RldklpUy9MaTZSOVExa1l1K0dN?= =?utf-8?B?ejVoVEJCVCtxSWFUVkhUTFFHVnBYOWlGcDB5SWIyQ1IyNWRBR2M3aUJPL3hT?= =?utf-8?B?UVFOV0xsTEJrSFhhZjFodmFXb0F5akxpd1JwRjhUM1ViT2k5RTA2eG8yT1N5?= =?utf-8?B?V1ZlTnNiOE9ZR3I2cTc3cXd5YVM4QVZqVW8wZkZLa09adXVBZW96YjNkQjBJ?= =?utf-8?B?WGNJUm5kQ21zekN0T1BETS95NCtqbk44YkQva2FGTXhpcEMySkxEaWlMbkxE?= =?utf-8?B?V1dyejVsa0FLMjFscngzdTZRZ2VnUENlTC9SU1NtR0plSHhiOEtjNmhMdzBu?= =?utf-8?B?dCtOb0doa0crbmZJN1RlS3JibW03aGpKV1pnaTdvdktieGFzWG5GSCtXOVFo?= =?utf-8?B?L2VIaHJTRHpYSWt6WWtMelVVVXpjcGw3VDN5SmtuZ1BlRi9aWG8yK2xNQkpq?= =?utf-8?B?Z2QyVGtZYzFyRnZKQlRlbWkyeGVQRGY0ZE82SFBaZkxIMEpEcXBDd1BkSXNZ?= =?utf-8?B?RHZkNG9TSFJjQlo1RHlZZi80MEtteWFTcjlSdmhjQmd6REorc3IwNmdvN21M?= =?utf-8?B?MTlwclRZUmxzZkgzRDFpNUxXU2xsTVNRam1EOU1PbFFTdGpsTjNRRG9KVFZj?= =?utf-8?B?VHdqTm5USDBObmdZcTdkRDhUREtpUzRzV25pOE9EQXVLNkN3UmNobzFWeUU2?= =?utf-8?B?VUxvaDVRNVZHR01tNTB6U29WeXFzWU9NT3prZTRKZVlES2hoY01zeTVvQVh4?= =?utf-8?B?MWxCYkZFc3pZcXFSNmE4dU9hNU1VUkppYVFiWnZYb0RJL0I5V0hCUGdKZ003?= =?utf-8?B?Nlo1Uzg4cTRlUSsvMVYwYWwvRmVVMkFlY1dBSWlsMTM3cEI0OERnYjRZc0pu?= =?utf-8?Q?TYtGTNHtAX6B8nVkZzy2CDBDz?= Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 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: 51ddd1ab-2534-43d9-9526-08dde72a52f8 X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Aug 2025 18:31:52.2746 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 9d5f83d3-d338-4fd3-b1c9-b7d94d70255a X-MS-Exchange-Transport-CrossTenantHeadersStamped: SA1PR09MB11260 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhhbmtzLCBUb20uIFRoYXQgd29ya2VkIQ0K