Re: Retrieve filename within a script

2024-11-15 Thread Vincent Veyron
On Thu, 14 Nov 2024 08:42:36 + Patrick FICHE wrote: > I was wondering if it was possible to get the filename provided as an > argument to psql. > psql -f /tmp/test.sql > Since you know it already, you could pass it as a variable : psql -f /tmp/test.sql -v my_path='/tmp/test.sql' and retr

Re: Retrieve filename within a script

2024-11-15 Thread Adrian Klaver
On 11/14/24 00:42, Patrick FICHE wrote: Hi, I was wondering if it was possible to get the filename provided as an argument to psql. Not that I know of. 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, P

Retrieve filename within a script

2024-11-14 Thread Patrick FICHE
Hi, I was wondering if it was possible to get the filename provided as an argument 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