From: Patrick FICHE <Patrick.Fiche@aqsacom.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Retrieve filename within a script
Thread-Topic: Retrieve filename within a script
Thread-Index: Ads2cNSsvdxViRdfSSuwI9/UQ6sq9A==
Date: Thu, 14 Nov 2024 08:42:36 +0000
Message-ID:
 <DUZPR05MB110211E125949ECF03413C533EF5B2@DUZPR05MB11021.eurprd05.prod.outlook.com>
Accept-Language: en-US, fr-FR
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?us-ascii?Q?HR/OJCqEPwNWVFq/4VHhl6ho/tk8ml57Dk7ZZB7eqHX4gIpdywGOZPCnWDHu?=
 =?us-ascii?Q?rvL3ZISjx1aT3PQ99W8th5LBtuSJgB80C8TVMGaKHMpQCTD2kf96xS5yuEke?=
 =?us-ascii?Q?cjBoUPYssnA8B3eHXW8cKINS9HIZcrE2rj5CN1Qk2GVpL0eAqicSt21KG8M7?=
 =?us-ascii?Q?CJsxb27DbTr3PTU8GFUrB8xCh9/jp+Qb5T0IbhrYqRS/QTlhn4bdEy7J249K?=
 =?us-ascii?Q?wELcS4x96aW8CuHsJIEwCi+TM2RlClojTtwYlWfNlRRuuOOlxVcSFijzzWB0?=
 =?us-ascii?Q?mE40fHmyT5kvFP/5hROl5lbORRnBeQJPsFeL/kcn2MztGbS9V+ugV9HurLSh?=
 =?us-ascii?Q?DdTbwHUwSYP2bCh8CCC+LAsAqloGSYHDHNpQ7BVuAXRMo/RqNraWsqU3Z2uZ?=
 =?us-ascii?Q?T3oGwO0ctPdudfBPwIzz/nGdt1evsl+Ijz//IjcnHyDk8nFeQOQzqsRh4xxY?=
 =?us-ascii?Q?M2eEfBaR4zRc5R95XizUfC1AgN2VU9R0a70VZeBocl2iODc8i8tZADzy1fTg?=
 =?us-ascii?Q?WKAu5RCsMV41NcDNE/kNbRb9F3JdFlTr3Ah4wLdpgdq7Drdxw1rbZ1RLzCdg?=
 =?us-ascii?Q?QFaectUnRXMe8KgX85Q9bDW4+SmanZ0IodZHGKuftOvymvoP5cIrllLAzSCo?=
 =?us-ascii?Q?1noWLJGcbgiFjlziHqF07y+j6heUrhIYKxYyaz+mtUiMtdlq8BShC1CeVBAa?=
 =?us-ascii?Q?qcx2147A/dhX/DTC7aOaDELrVZBUUusPLEBGekzGPsUy05kFxSGj5umCZu9d?=
 =?us-ascii?Q?kCrWa26N79HU87yvsb6CdDe+Oq+lEyGrw9RSEwojVwvzCOuD5BaVLR/rdL3u?=
 =?us-ascii?Q?iZyyszFTi2L64yWMtexrlDzjejsCnhyCSYjq7WcPF+IY38+1OYWULfJ8w9iE?=
 =?us-ascii?Q?DQYJHJLcNikKMa8QSPD/jFedetvfLEqV3KlNjI0R0wgyx/YPNP2fNMfgq2m6?=
 =?us-ascii?Q?P+A5eUjKFXEK99EvB9cSFopLladR2+oeRSYKJ6jtHIPoUxyICJ4U3hIiEfTV?=
 =?us-ascii?Q?Ih4zRWLPznukwtvcDJuF/BjeJPHw0fPwygECo6TY35RCngBoSawzVtqsuJPD?=
 =?us-ascii?Q?Ma0M3sGu8usZ8RdHtrCRVKYcld3D1T5dFTj6Lv4gJLOSbG3ONMj/eiD7O3TI?=
 =?us-ascii?Q?MLkNegIvz7IOwE+Wer9iiOhmdn7lg1nosQ2UbSIY86rk0o8U6Q5hDlNQpv3p?=
 =?us-ascii?Q?h+xRNUP3Ud1lg0pd1t/j1ihDdu7CT61JyyzxXWEzf7fb2SdyikDGqBK0QCBN?=
 =?us-ascii?Q?qv8pRTIyj79ENSkeNj3koAsVid9fJjAc8IKpV9iAeyyrf5DjSOCrWQYVusKe?=
 =?us-ascii?Q?BVT73f2NuA55IcOmREpxNnWcY4T37mBs6YyX8i9jdAfOSFSgsLA+6dM2ee4F?=
 =?us-ascii?Q?DwRnVjGuKigboYRiaKERPL2tU0+OGAlB+9A/3on0+hbYU8KtrTUzaM6Hxdqo?=
 =?us-ascii?Q?EUia5q8wlkdOQemwEJVuUZu3mlEMPgVg8bjzhFkGSvgsgwLjJZQTrJDbNPjn?=
 =?us-ascii?Q?EhtiClbpnsqdCIRkBLb+SPv2a322ppr6exxMjJEXnEYRzjMOP+99/aFt5aHM?=
 =?us-ascii?Q?50nMFny5T0I9BxmOQOFT+Q/xt010R8WMq7a66RBS?=
Content-Type: multipart/alternative;
	boundary="_000_DUZPR05MB110211E125949ECF03413C533EF5B2DUZPR05MB11021eu_"
MIME-Version: 1.0
X-OriginatorOrg: aqsacom.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: DUZPR05MB11021.eurprd05.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 57bafb78-979d-4bd5-7f67-08dd04884a69
X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Nov 2024 08:42:36.6484
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 91f6be4c-f21e-43f0-9149-3a24dbb5c188
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: JCi84mUa5l31xOXhVk+WS6WNx2jgOKVh46KV8H9Ljuq2mkeMfl56YhqEhM6CYeBM91keTJaRcwIcCdwjeKuV4JUOQvMcIMjFzsMjr57sFAs=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM9PR05MB8859
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/DUZPR05MB110211E125949ECF03413C533EF5B2%40DUZPR05MB11021.eurprd05.prod.outlook.com>
Precedence: bulk

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

Hi,

I was wondering if it was possible to get the filename provided as an argum=
ent to psql.
psql -f /tmp/test.sql

I would like a command in test.sql that would be able to retrieve the full =
pathname (/tmp/test.sql).

Regards,


Patrick


--_000_DUZPR05MB110211E125949ECF03413C533EF5B2DUZPR05MB11021eu_
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:Aptos;}
@font-face
	{font-family:Cambria;
	panose-1:2 4 5 3 5 4 6 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:11.0pt;
	font-family:"Aptos",sans-serif;
	mso-ligatures:standardcontextual;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Aptos",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:11.0pt;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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"#467886" vlink=3D"#96607D" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">Hi,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I was wondering if it was possible to get the filena=
me provided as an argument to psql.<o:p></o:p></p>
<p class=3D"MsoNormal">psql -f /tmp/test.sql<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">I would like a command in test.sql that would be abl=
e to retrieve the full pathname (/tmp/test.sql).<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal">Regards,<o:p></o:p></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"MsoNormal"><span style=3D"mso-ligatures:none"><o:p>&nbsp;</o:p>=
</span></p>
<p class=3D"MsoNormal" style=3D"text-align:justify"><span style=3D"font-siz=
e:10.0pt;font-family:&quot;Cambria&quot;,serif;mso-ligatures:none">Patrick
</span><span style=3D"font-family:&quot;Cambria&quot;,serif;mso-ligatures:n=
one"><o:p></o:p></span></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
</body>
</html>

--_000_DUZPR05MB110211E125949ECF03413C533EF5B2DUZPR05MB11021eu_--